SQL Server Transact Basic to Expert - To See index metadata

This blog show how to get the details of an index and its metadata using the below query

Syntax:

Exec sp_helpindex 'Schema.Tablename'


Example:

EXEC sp_helpindex 'Dbo.EmpTable'