Get a table/SP list using ADO (Views: 705)
|
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); |