GetODBCTables()
Summary
Gets a list of all the tables in an ODBC data source.
Syntax
table_names = GetODBCTables(string odbc_data_source_name)
| Argument | Contents |
|---|---|
| odbc_data_source_name | Name of an ODBC data source |
Returns
An array of two (2) elements (null if an error occurred or there are no tables in the ODBC data source):
| Element | Type | Contents |
|---|---|---|
| 1 | Array | An array of table names (strings) |
| 2 | Array | An array of schema names (strings) |
Notes
-
An ODBC data source can be set up with the ODBC setup or administrator program.
-
GetODBCTables() calls the ODBC API function SQLTables, and only returns tables whose TableType (as defined by SQLTables) is one of the following: TABLE, VIEW, ALIAS or SYNONYM. See ODBC API documentations for details.
-
The schema name for any table may be null.
See Also
| Function | Summary |
|---|---|
| GetODBCDataSourceInfo() | Gets information about an ODBC data source |
| GetODBCDataSourceNames() | Gets an array of the names of all defined ODBC data sources |
| GetODBCFields() | Gets a list of all the fields in an ODBC table |