回复：求助：谁知道怎么通过sql 语句就知道某个表的聚集索引是升序还是降序？
--查看表索引信息
select i.name as index_name,i.type_desc,is_unique,is_primary_key,
is_unique_constraint,
c.name as col_name,key_ordinal,is_descending_key,is_included_column,
fill_factor,is_padded,allow_row_locks,allow_page_locks
from sys.indexes as i
inner join sys.index_columns as IL on i.index_id=IL.index_id and i.object_id=IL.object_id
inner join sys.columns as c on IL.column_id=c.column_id and IL.object_id=c.object_id
where i.object_id=object_id('dbo.Table')
order by IL.index_id asc,IL.index_column_id asc
注：联机丛书上关于INDEXKEY_PROPERTY函数 说
| 重要提示： |
| 后续版本的 Microsoft SQL Server 将删除该功能。请避免在新的开发工作中使用该功能，并着手修改当前还在使用该功能的应用程序。可改用 sys.index_columns (Transact-SQL)。 |
