List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:May 2 2005 7:08pm
Subject:Re: table that keeps info on tables in a DB
View as plain text  
 >which sytem table is checked when 'show tables'
 >command is executed in MYSQL ?

Before 5.03 it's just an internal MySQL command. Since 5.03 it's a View 
defined in the information_schema virtual database. In neither case is 
it a physical table.

PB

-----

V. Agarwal wrote:

>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 
>
>  
>


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.1 - Release Date: 5/2/2005

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