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'


Ebook Download
View all
Learn
View all