From: Peter Brawley
Date: May 2 2005 7:08pm
Subject: Re: table that keeps info on tables in a DB
List-Archive: http://lists.mysql.com/mysql/183519
Message-Id: <42767AC2.6040903@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

 >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