sp_statistics

Returns a list of indexes in a single table.

Syntax

sp_statistics table_name [, table_owner]
 [, table_qualifier] [, index_name] [, is_unique]

Parameters

table_name – is name of the table. Wildcard-character search patterns are not supported.
table_owner – is the owner of the table.
table_qualifier – is ignored. Leave blank or set to NULL.
is_unique – is one of :
- “Y” if unique indexes are to be returned.
- “N” if unique indexes are not to be returned.
index_name – is the name of the index. Wildcard-character search patterns are not supported.

Usage

This procedure corresponds to the ODBC function SQLStatistics.

Note: With all platforms in ECDA Option for ODBC, the index_name parameter is ignored, regardless of the value. This applies even if you set the value to a nonexistent name or to NULL.