"V. Agarwal" <vka3@stripped> wrote on 05/02/2005 02:26:28 PM:
> which sytem table is checked when 'show tables'
> command is executed in MYSQL ?
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
There isn't one. This is not MS SQL server (or MS Access). MySQL keeps
that information (along with all other schema related info) in several
internal data structures, not in separate tables (and those internal
structures even differ depending on which storage engine a table uses).
As of 5.0 you can query against the INFORMATION_SCHEMA views but not
before. The only way to get at the server's schema information in the
MySQL versions before 5 is to parse that information out of the "SHOW xxx"
family of commands.
Unimin Corporation - Spruce Pine