SQL to list table names

2005-04-21 Thread Darryl Hoar
Greetings, I am running Mysql 3.23. Is there an sql statment that will allow me programmatically to retrieve the names of the tables in a database ? thanks, Darryl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: SQL to list table names

2005-04-21 Thread Paul DuBois
At 10:22 -0500 4/21/05, Darryl Hoar wrote: Greetings, I am running Mysql 3.23. Is there an sql statment that will allow me programmatically to retrieve the names of the tables in a database ? http://dev.mysql.com/doc/mysql/en/show-tables.html ? -- Paul DuBois, MySQL Documentation Team Madison,

Re: SQL to list table names

2005-04-21 Thread Frank Bax
At 11:22 AM 4/21/05, Darryl Hoar wrote: I am running Mysql 3.23. Is there an sql statment that will allow me programmatically to retrieve the names of the tables in a database ? show tables; Yes, this is an SQL statement! -- MySQL General Mailing List For list archives:

Re: SQL to list table names

2005-04-21 Thread Chris Ramsay
http://dev.mysql.com/doc/mysql/en/show-tables.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]