T-SQL sp_helpindex

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.
Returns 0 for success or error message for failure.

sp_helpindex syntax:

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


sp_helpindex example:

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