4D v13

ODBC_SQLStatistics

Home

 
4D v13
ODBC_SQLStatistics

ODBC_SQLStatistics 


 

ODBC_SQLStatistics ( stmtID ; catalogName ; schemaName ; tableName ; unique ; reserved ) -> Function result 
Parameter Type   Description
stmtID  Longint in Statement ID
catalogName  String in Catalog name
schemaName  String in Schema name
tableName  String in Table name
unique  Longint in Type of index
reserved  Longint in Indicates the importance of the CARDINALITY and PAGES columns
Function result  Longint in Returns the result of the MS ODBC API function SQLStatistics

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 Reference at http://msdn.microsoft.com/en-us/library/ms711022(VS.85).aspx.

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.

 
PROPERTIES 

Product: 4D
Theme: ODBC_Catalog functions
Number: 16939

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D ODBC Pro 2004