[MSSQL] 查詢Index資料
SELECT obj.name TableName, ind.name IndexName, col.name IndexColumn, incol.index_column_id IndexColumnSN FROM sys.columns col INNER JOIN sys.objects obj ON obj.object_id = col.object_id INNER JOIN sys.index_columns incol ON incol.COLUMN_ID = col.column_id AND incol.object_id = obj.object_id INNER JOIN sys.indexes ind on ind.index_id = incol.index_id AND obj.object_id = ind.object_id WHERE obj.name = 'TableName' order by ind.name, incol.index_column_id