SQL server 查看某张表的索引

原创已于 2024-08-29 09:55:38 修改 · 587 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #sql #mysql

于 2024-08-28 19:38:50 首次发布

SELECT 
    t.name AS TableName,
    i.name AS IndexName,
    ic.column_id,
    c.name AS ColumnName,
    i.type_desc
FROM 
    sys.tables t
INNER JOIN 
    sys.indexes i ON t.object_id = i.object_id
LEFT JOIN 
    sys.index_columns ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
LEFT JOIN 
    sys.columns c ON ic.object_id = c.object_id AND ic.column_id = c.column_id
WHERE 
    t.name = 'dwd_contractlist_ext'
ORDER BY 
    i.name, ic.key_ordinal;