|
|
| Line 1: |
Line 1: |
| − | [[Category:Database Functions]] | + | #REDIRECT [[DbTableNames]] |
| − | [[Category:Doc Status D]] <!-- For Lumina use, do not change -->
| |
| − | | |
| − | = 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