sp_helpindex (Transact-SQL)
SQL Server 2008
Reports information about the indexes on a table or view.
Column name | Data type | Description |
|---|---|---|
index_name | sysname | Index name. |
index_description | varchar(210) | Index description including the filegroup it is located on. |
index_keys | nvarchar(2078) | Table or view columns 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.
