Mirror

Get a table/SP list using ADO (Views: 13)


Problem/Question/Abstract:

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:

{we want to receive the tables including the system tables}
boolSystemTables := True;
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);

<< Back to main page