List:General Discussion« Previous MessageNext Message »
From:SGreen Date:May 2 2005 7:01pm
Subject:Re: table that keeps info on tables in a DB
View as plain text  
"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 
> 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
Thread
table that keeps info on tables in a DBV. Agarwal2 May
  • Re: table that keeps info on tables in a DBSGreen2 May
  • Re: table that keeps info on tables in a DBPeter Brawley2 May
  • Re: table that keeps info on tables in a DBRhino2 May