如何查看非聚集索引的信息，比如建等。
select * from sysobjects查看不到非聚集索引的信息，所以我想：
如何查看非聚集索引的信息，比如建等。


Sysobjects:


[解决办法]

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='表名'
[解决办法]
探讨

上的思路有。

但有提供查看非聚集索引是何建（或修改）的信息。

[解决办法]
也可以用存储过程
exec sp_autostats '表名' 查看一个表的索引的统计信息 有上次修改的时间
[解决办法]
探讨

http://blog.csdn.net/lvjin110/article/details/6935150




SQL code

--查看索引的信息（包含建及修改）
select
    o.name as 表名,
    i.name as 索引名,
    c.name as 列名,
    i.type_desc as 型描述,
    is_pr……