sp_statistics

Description

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 the following values:

index_name

is the name of the index. Wildcard-character search patterns are not supported.

Usage

NoteWith 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.

This procedure corresponds to the ODBC function SQLStatistics.