Describe Index in SQL Server

In next couple of posts i will explain about some very usefull stored procedures in SQL Server.

SP_HELPINDEX: SP_HELPINDEX (TABLE)

The sp_helpindex stored procedure is used to display the indexes that are created on a table based on the input parameter. In addition to the indexes it will also display the columns which are part of the indexes.


USE Pubs;
GO
EXEC sp_helpindex N'HR.Employee';
GO