Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

sp_helpindex

SQL Server 2000

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

See Also

CREATE INDEX

DROP INDEX

DROP STATISTICS

sp_help

sp_statistics

System Stored Procedures

UPDATE STATISTICS

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.