摘要:
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... 阅读全文