Events
Sep 15, 6 AM - Sep 17, 3 PM
The best SQL community-led learning event. Sept 2025. Save €200 with code FABLEARN.
Get registeredThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Reports information about the indexes on a table or view.
Transact-SQL syntax conventions
sp_helpindex [ @objname = ] N'objname'
[ ; ]
The qualified or nonqualified name of a user-defined table or view. @objname is nvarchar(776), with no default. 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.
0
(success) or 1
(failure).
Column name | Data type | Description |
---|---|---|
index_name |
sysname | Index name. |
index_description |
varchar(210) | Index description, including the filegroup in which it's located. |
index_keys |
nvarchar(2078) | Table or view columns upon which the index is built. |
A descending indexed column is listed in the result set with a minus sign (-
) following its name; an ascending indexed column, the default, is listed by its name alone.
If indexes are set by using the NORECOMPUTE
option of UPDATE STATISTICS
, that information is included in the index_description
column.
sp_helpindex
exposes only orderable index columns; therefore, it doesn't expose information about XML indexes or spatial indexes.
Requires membership in the public role.
The following example reports on the types of indexes on the Customer
table in AdventureWorks2022
.
USE AdventureWorks2022;
GO
EXECUTE sp_helpindex N'Sales.Customer';
GO
Events
Sep 15, 6 AM - Sep 17, 3 PM
The best SQL community-led learning event. Sept 2025. Save €200 with code FABLEARN.
Get registeredAsk Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.
Please sign in to use Ask Learn.
Sign in