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:
- index name
- index description (clustered, nonclustered, etc.)
- index keys
Applies to SQL Server 2000, 2005 and 2008.