DbTableNames
DbTableNames(connectionString, cat, sch, tab, typ)
Connects to an ODBC data source and returns catalog data for the data source.
«ConnectionString» specifies a data source (e.g., 'DSN = MyDatabase'). «Cat» (catalog names), «sch» (schema names), «tab» (table names), and «typ» (table types) may be patterns if your ODBC driver manager is ODBC 3 compliant.
Use ‘%’ as a wildcard in each field to match zero or more characters. Underscore, ‘_’, matches one character. Most drivers use backslash ('\') as an escape character, so that the characters ‘%’, ‘_’, or ‘\’ as literals must be entered as ‘\%’, ‘\_’, or ‘\\’.
«Typ» may be a comma-delimited list of table types. Your data source and ODBC driver may or may not support this call to varying degrees.
Examples
To get all valid catalog names in My db:
DBTableNames(‘DSN = My db’, ’%’, ’’, ’’, ’’)
To get all valid schemas in My db:
DBTableNames(‘DSN = My db’,’ ’, ’%’, ’’, ’’)
To get all valid table names in My db:
DbTableNames(‘DSN = My db’,’’,’’,’%’,’’)
To get all valid table types:
DbTableNames(‘DSN = My db’, ’’, ’’, ’’, ’%’)
Enable comment auto-refresher