Names of Tables for ListBox

[Blekk]

Hi, I am creating a database, and on the first form I want a listbox displaying the names of all the tables, so when a user clicks on one and clicks the OK button, it will open another form showing the data in that table. What I need to know is how to get the names of the tables in the database without hard coding it. Thanks in advance, Any reply is appreciated.

[Robert Rohde]

Hi, have a look at the GetSchema[^] on your connection class. I think it doesn't work on every database and it's also not very comfortable to get the results out of the returned DataTable but it worked for me when wokring with Access databases. Robert

[Noman Nadeem]

Well, it would help if you mentioned which database you are working with. I can help you with oracle: for all tables: 'select table_name from dba_tables;' for tables for a specific owner: 'select table_name from dba_tables where owner = 'XYZ';' for all the tables you have access to: 'select table_name from all_tables'; based on the result you may fill the listbox ! hope this helps

regards, Noman Nadeem :zzz: