SqlServer 查询所有的索引

 

--查询库中所有的索引
select 
a.name as tableName,
h.name as IndexName
from  sys.objects    as  a 
right join sys.indexes  as h  on  a.object_id=h.object_id
 where  a.type='u'