version 2004
ODBC_SQLColumns (stmtID; catalogName; schemaName; tableName; columnName) 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 | |
columnName | String | String search pattern for column names | |
Function result | Longint | Returns the result of the MS ODBC API function | |
SQLColumns |
Description
The ODBC_SQLColumns command returns the list of column names in specified tables. The driver returns this information as a result set on the specified stmtID.
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.
columnName is the string search pattern for column names.
For more information, please see the SQLColumns function in the MS ODBC API at http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlcolumns.asp.
Function Results
SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.
See Also