SQL SERVER 根据表名查找唯一索引、主键、索引的所有字段
SELECT a.name IndexName,d.COLUMN_NAME,d.ORDINAL_POSITION
FROM sys.indexes a (NOLOCK)
INNER JOIN sys.index_columns b (NOLOCK) ON a.object_id = b.object_id and a.index_id = b.index_id
INNER JOIN sysin...
原创
2019-03-17 10:22:23 ·
4199 阅读 ·
0 评论