SQLStatistics

This function retrieves index information for a given table

Syntax :

RETCODE SQLStatistics (hstmt, catalogName, lenCatalogName, schemaName, lenSchemaName, tableName, unique, accuracy);

Arguments :

The arguments for SQLStatistics are listed in below table.

Type	Name	Description
SQLHSTMT	hstmt	Statement handle.
SQLCHAR*	catalogName	Catalog qualifier of a 3 part table name. This must be a NULL pointer or a zero length string.
SQLSMALLINT	lenCatalogName	Length of catalogName. This must be set to 0.
SQLCHAR*	SchemaName	Buffer that might contain a pattern-value to qualify the result set by schema name.
SQLSMALLINT	lenSchemaName	Length of SchemaName
SQLCHAR*	tableName	Buffer that might contain a pattern-value to qualify the result set by table name.
SQLSMALLINT	lentableName	Length of tableName
SQLSMALLINT	unique	Type of index information to return: SQL_INDEX_UNIQUE (Only unique indexes are returned) or SQL_INDEX_ALL (All indexes are returned.)
SQLSMALLINT	accuracy	Not currently used, must be set to 0.

Page last modified on September 26, 2009, at 01:52 AM