odbc_databaseGetTableNames ( db_pointer As User, _
catalog As String, _
schema As String, _
Optional ignoreErrors? As Boolean = False ) As List| Argument | Type | Description |
|---|---|---|
| db_pointer | user | Database reference. This reference should be obtained with the previous call to odbc_databaseOpen |
| catalog | string | Catalog name |
| schema | string | Schema name |
| ignoreErrors? | boolean | Optional; if the argument is True, then database errors are not reported as Intent exceptions; default is False. |
Obtain the table names from the database
Dim db As User = odbc_databaseOpen( "ODBC;DSN=PEFRESULTS")
Dim catalogues As List = odbc_databaseGetCatalogNames( db)
Dim tables As List = odbc_databaseGetTableNames( db, First(catalogues), "")
Intent >odbc_databaseClose( db)
--> {"MSysAccessStorage", "MSysAccessXML", "MSysACEs", "MSysComplexColumns", "MSysNavPaneGroupCategories", "MSysNavPaneGroups", "MSysNavPaneGroupToObjects", "MSysNavPaneObjectIDs", "MSysObjects", "MSysQueries", "MSysRelationships", "Customer", "Table1"}