SQL Server主键列的正确查看方式
作者:应用开发 来源:域名 浏览: 【大中小】 发布时间:2025-11-04 14:08:07 评论数:
复制SELECT sysobjects.name,键列syscons.name,syscolumns.name From sysobjects inner join syscolumns on sysobjects.id = syscolumns.id left outer join (select o.name sTableName, c.Name sColName From sysobjects o inner join sysindexes i on o.id = i.id and (i.status & 0X800) = 0X800 inner join syscolumns c1 on c1.colid <= i.keycnt and c1.id = o.id inner join syscolumns c on o.id = c.id and c.name = index_col (o.name, i.indid, c1.colid)) pkElements on pkElements.sTableName = sysobjects.name and pkElements.sColName = syscolumns.name inner join sysobjects syscons on sysobjects.id=syscons.parent_obj and syscons.xtype=’PK’ where sysobjects.name in (’TAB1’,’TAB2’......) and sTableName is not null order by --Case (syscolumns.Status & 128) when 128 then 1 else 0 end DESC, sysobjects.name 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.