sp_helpindex

Reports information about the indexes on a table or view.

Syntax

sp_helpindex [ @objname = ] 'name'

Arguments

[@objname =] 'name'

Is the name of a table or view in the current database. name is nvarchar(776), with no default.

Return Code Values

0 (success) or 1 (failure)

Result Sets

Column name	Data type	Description
index_name	sysname	Index name.
index_description	varchar(210)	Index description.
index_keys	nvarchar(2078)	Table or view column(s) upon which the index is built.

A descending indexed column will be listed in the result set with a minus sign (-) following its name; an ascending indexed column, the default, will be listed by its name alone.

Remarks

If indexes have been set with the NORECOMPUTE option of UPDATE STATISTICS, that information is shown in the result set of sp_helpindex.

Permissions

Execute permissions default to the public role.

Examples

This example reports on the types of indexes on the sysobjects table.

sp_helpindex sysobjects