Author: Mike Shkolnik
How can I receive the list of table names in ADO?
Answer:
If you needs to retrieve the list of available tables in ADO, you can call the
GetTableNames method of your TADOConnection component:
1 2 {we want to receive the tables including the system tables}3 boolSystemTables := True;
4 yourADOConnection.GetTableNames(yourListBox.Items, boolSystemTables);
if you want to recieve the names of stored procedures, you must call the
GetProcedureNames method:
yourADOConnection.GetProcedureNames((yourListBox.Items);