摘要: select i.name,[Type]=case when i.is_unique=1 and is_primary_key=1 then '主键' when i.is_unique=1 and is_primary_key=0 then '唯一键' else '索引' end,TypeRemark=i.type_desc from sys.indexes i where i.[object_id]=object_id('表名') and i.name is not null unio... 阅读全文
posted @ 2013-03-04 23:11 csdnbbs 阅读(298) 评论(0) 推荐(0) 编辑