sp_helpindex (Transact-SQL)
Reports information about the indexes on a table or view.
Transact-SQL Syntax Conventions
- [ @objname = ] 'name'
-
Is the qualified or nonqualified name of a user-defined table or view. Quotation marks are required only if a qualified table or view name is specified. If a fully qualified name, including a database name, is provided, the database name must be the name of the current database. name is nvarchar(776), with no default.
| 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.
