Get a list of the tables of a database

Get a list of the tables of a database

Postby madbat870 » Tue 31 Jan 2006 14:50

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!
madbat870
 
Posts: 2
Joined: Tue 31 Jan 2006 14:42
Location: Brescia (Italy)

Postby GEswin » Tue 31 Jan 2006 14:59

With command "SHOW TABLES;" you should get tables of selected database. (If you need to know databases available, then "SHOW DATABASES;").
GEswin
 
Posts: 186
Joined: Wed 03 Nov 2004 16:57
Location: Spain

Postby madbat870 » Tue 31 Jan 2006 22:14

:D Thanks a lot! :D
madbat870
 
Posts: 2
Joined: Tue 31 Jan 2006 14:42
Location: Brescia (Italy)


Return to MySQL Data Access Components