如何在SQL Server中查找特定索引的所有列？

SELECT 
    c.name AS 'Column Name'
FROM 
    sys.indexes AS i
INNER JOIN 
    sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN 
    sys.columns AS c ON ic.object_id = c.object_id AND ic.column_id = c.column_id
WHERE 
    i.object_id = OBJECT_ID('YourTableName') -- 替换为你的表名
    AND i.name = 'YourIndexName' -- 替换为你的索引名