Chapter 11: Accessing Catalog Information with CSPs

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:

“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

With all platforms in DirectConnect, 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.

View this book as PDF