At some time today, I had to compare the indices of various database tables.
To this end, I needed a fast way of getting index information for specific tables.
In SQL Server, there is a system stored procedure (hosted in the master
database) called sp_helpindex
The syntax for using it is the following:
EXEC sp_helpindex 'schema.table_name'
The execution of the stored procedure will return the following information for all the indices in the given table:
Applies to SQL Server 2000, 2005 and 2008.
- index name
- index description (clustered, nonclustered, etc.)
- index keys
Labels: Indexes, SQL Server 2000, SQL Server 2005, SQL Server 2008