WITH tmp
AS ( SELECT indexname = a.name ,
tablename = c.name ,
indexcolumns = d.name ,
a.indid
FROM sysindexes a
JOIN sysindexkeys b ON a.id = b.id
AND a.indid = b.indid
JOIN sysobjects c ON b.id = c.id
JOIN syscolumns d ON b.id = d.id
AND b.colid = d.colid
WHERE a.indid NOT IN ( 0, 255 )
-- and c.xtype='U' and c.status>0 -- 查所有用户表
AND c.name = 'T_Houses' --查指定表
)
SELECT tmp.indexname '索引名称' ,
tmp.tablename '表名' ,
( SELECT A.indexcolumns + ','
FROM tmp A
WHERE A.indexname = tmp.indexname
AND A.indid = tmp.indid
FOR
XML PATH('')
) AS '索引列' ,
tmp.indid '索引id'
FROM tmp
GROUP BY tmp.indexname ,
tmp.tablename ,
tmp.indid
![SQL server查找指定表的所有索引 SQL server查找指定表的所有索引](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvODE1NjIyLzIwMTgwOC84MTU2MjItMjAxODA4MDExNzMxMDY2MDUtMTczNzg2OTk1NS5wbmc%3D.png?w=700&webp=1)