Get a list of the tables of a database

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
madbat870
Posts: 2
Joined: Tue 31 Jan 2006 14:42
Location: Brescia (Italy)

Get a list of the tables of a database

Post by 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!
Top
GEswin
Posts: 186
Joined: Wed 03 Nov 2004 16:57
Location: Spain
Contact:
Contact GEswin

Post by 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;").
Top
madbat870
Posts: 2
Joined: Tue 31 Jan 2006 14:42
Location: Brescia (Italy)

Post by madbat870 » Tue 31 Jan 2006 22:14

:D Thanks a lot! :D
Top
Post Reply

Return to “MySQL Data Access Components”