"V. Agarwal" <[EMAIL PROTECTED]> 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 > http://mail.yahoo.com > 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. Shawn Green Database Administrator Unimin Corporation - Spruce Pine