Page 1 of 1

Get a list of the tables of a database

Posted: Tue 31 Jan 2006 14:50
by madbat870
I'm italian, so my english could be not so exact... :-)
How can i get the list of the tables of a database at run-time so that the user can select the table to visualize after he had connected to a database? thanks!

Posted: Tue 31 Jan 2006 14:59
by GEswin
With command "SHOW TABLES;" you should get tables of selected database. (If you need to know databases available, then "SHOW DATABASES;").

Posted: Tue 31 Jan 2006 22:14
by madbat870
:D Thanks a lot! :D