请教表的索引对应的列及列顺序存储在哪个系统表里

with Index1as(select     top 100 percent row_number()over(partition by a.Name order by b.index_id) as ID,object_Name(a.object_id) as TableName,a.Name as IndexName,c.Name as ColName,    description=a.type_desc,a.is_unique,a.is_primary_key,a.is_unique_constraint,OrderNr=CASE WHEN b.is_descending_key=0 THEN 'Asc' ELSE 'DESC' ENDfrom     sys.indexes a join    sys.index_columns b on a.Object_id=b.Object_id and a.index_id=b.index_id join    sys.columns c on c.object_id=a.object_id and c.column_id=b.column_idwhere     objectproperty(a.object_id,'IsUserTable')=1 and a.Object_id<>object_id('dtproperties')order by TableName,a.Name),index2as(select     TableName,IndexName,ColName,is_unique,is_primary_key,is_unique_constraint,descriptionfrom     (select  distinct TableName,IndexName,is_unique,is_primary_key,is_unique_constraint,description from Index1)aCROSS apply    (select ColName=stuff((select ','+ColName +' '+OrderNr from Index1 where TableName=a.TableName and IndexName=a.IndexName order by ID for xml PATH('')),1,1,''))b)select     * from     index2order by TableName,IndexName
------解决方案--------------------
SQL code
--结合sys.indexes和sys.index_columns,sys.objects,sys.columns查询索引所属的表或视图的信息select  o.name as 表名,  i.name as 索引名,  c.name as 列名,  i.type_desc as 类型描述,  is_primary_key as 主键约束,  is_unique_constraint as 唯一约束,  is_disabled as 禁用from  sys.objects o inner join  sys.indexes ion  i.object_id=o.object_idinner join   sys.index_columns icon  ic.index_id=i.index_id and ic.object_id=i.object_idinner join  sys.columns con  ic.column_id=c.column_id and ic.object_id=c.object_idgo--查询索引的键和列信息select   o.name as 表名,  i.name as 索引名,  c.name as 字段编号,from  sysindexes i inner join sysobjects o on  i.id=o.idinner join  sysindexkeys k on  o.id=k.id and i.indid=k.indidinner join  syscolumns c on  c.id=i.id and k.colid=c.colidwhere  o.name='表名'