Re: table that keeps info on tables in a DB

2005-05-02 Thread Rhino
- Original Message - From: "V. Agarwal" <[EMAIL PROTECTED]> To: Sent: Monday, May 02, 2005 2:26 PM Subject: table that keeps info on tables in a DB > which sytem table is checked when 'show tables' > command is executed in MYSQL ? > If you want to get information about your tables and

Re: table that keeps info on tables in a DB

2005-05-02 Thread Peter Brawley
>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 che

Re: table that keeps info on tables in a DB

2005-05-02 Thread SGreen
"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