Sp_helpindex - TSQL Tutorial

On Transact SQL language the sp_helpindex is part of Database Engine Stored Procedures and reports information about the indexes on a table or view.

Sp_helpindex syntax:

sp_helpindex [ @objname = 'Object name.' ] ;


Sp_helpindex example:

USE model;
GO
EXEC sp_helpindex N'Departments';
GO