Getting table index information in SQL Server

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.