sqlserver查看索引列排序信息

你可以使用以下 SQL 查询语句来查看 SQL Server 数据库中索引列的排序信息：

SELECT OBJECT_NAME(i.object_id) AS TableName, 
       i.name AS IndexName, 
       COL_NAME(ic.object_id,ic.column_id) AS ColumnName, 
       ic.is_descending_key 
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 
WHERE i.is_primary_key = 0 
  AND i.is_unique_constraint = 0 
  AND i.is_unique = 0 
  AND i.type <> 0 
ORDER BY OBJECT_NAME(i.object_id), i.name, ic.key_ordinal;

这个查询将返回每个索引列的表名、索引名称、列名和排序方向信息（升序或降序）。请注意，查询排除了主键、唯一约束和聚集索引，因为这些索引的排序方向是固定的。