|
|
|
|
|
|
|
|
|
version 2004
ODBC_SQLTables (stmtID; catalogName; schemaName; tableName; tableType) 
Longint
| Parameter | Type | Description | |
| stmtID | Longint | | Statement ID |
| catalogName | String | | Catalog name |
| schemaName | String | | String search pattern for schema names |
| tableName | String | | String search pattern for table names |
| tableType | String | | List of table types to match |
| Function result | Longint |  | Returns the result of the MS ODBC API function |
| SQLTables |
Description
The ODBC_SQLTables command returns the list of table, catalog, or schema names, and table types, stored in a specific data source.
stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.
catalogName is the catalog name.
schemaName is the string search pattern for schema names.
tableName is the string search pattern for table names.
tableType is the list of table types to match.
For more information, please see the SQLTables function in the MS ODBC API at http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqltables.asp.
Function Results
SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.
See Also
|
|
|
|
|
|
|
|
|