SQL Server DB中所有索引和索引列的列表

SELECT 
    t.NAME AS TableName,
    i.NAME AS IndexName,
    c.NAME AS ColumnName,
    ic.key_ordinal AS KeyOrdinal
FROM 
    sys.tables t
    INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id
    INNER JOIN sys.index_columns ic ON i.OBJECT_ID = ic.object_id AND i.index_id = ic.index_id
    INNER JOIN sys.columns c ON ic.object_id = c.object_id AND ic.column_id = c.column_id
WHERE 
    t.NAME = 'YourTableName'
ORDER BY 
    t.NAME,
    i.NAME,
    ic.key_ordinal