>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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]