查询sql索引
SELECT 索引名称 = a.name ,
表名 = c.name ,
索引字段名 = d.name ,
索引字段位置 = d.colid
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 = 'CS_CustomerServiceInfo' --查指定表
ORDER BY c.name ,
a.name ,
d.name