version 2004
ODBC_SQLStatistics (stmtID; catalogName; schemaName; tableName; unique; reserved) Longint
Parameter | Type | Description | |
stmtID | Longint | Statement ID | |
catalogName | String | Catalog name | |
schemaName | String | Schema name | |
tableName | String | Table name | |
unique | Longint | Type of index | |
reserved | Longint | Indicates the importance of the CARDINALITY and | |
PAGES columns | |||
Function result | Longint | Returns the result of the MS ODBC API function | |
SQLStatistics |
Description
The ODBC_SQLStatistics command retrieves a list of statistics about a single table and the indexes associated with the table.
stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.
catalogName is the catalog name.
schemaName is the schema name.
tableName is the table name.
unique indicates the type of index and can have one of the following values: SQL_INDEX_UNIQUE or SQL_INDEX_ALL.
reserved indicates the importance of the CARDINALITY and PAGES columns.
For more information, please see the SQLStatistics function in the MS ODBC API at http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlstatistics.asp.
Function Results
SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.