查询所有表索引

create table #tempindex(
tableName nvarchar(776),
index_name sysname,
index_description varchar(2000),
index_keys varchar(2000))

exec sp_msforeachtable 'insert into #tempindex(index_name,index_description,index_keys)
exec sp_helpindex ''?'';update #tempindex set tableName=''?'' where tableName is null '

select tableName AS '表名',index_name '索引名称',index_keys '索引列',index_description '索引描述' from #tempindex
--where index_description not like 'clustered%' --非聚集索引
order by tableName

drop table #tempindex