SQL Query – List Indexes

—- SQL Query – List Indexes

EXEC sp_helpindex 'tblgroups'

or

declare @tblName varchar(50);
set @tblName = 'tbltransaction';
SELECT     o.name as TableName, i.name AS IndexName
FROM         sysobjects o, sysindexes i
WHERE   (o.id = i.id and o.name = @tblName) AND (i.status = 18450 OR   i.status = 2097152)

Share this: