sp_helpindex (Transact-SQL)
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.
