22,210
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
昵称被占用了 2007-07-25
- 打赏
- 举报
select c.name from sysobjects o,sysindexes i,sysindexkeys k,syscolumns c
where o.xtype='PK'
and o.parent_obj=object_id('表名')
and i.id=o.parent_obj
and i.name=o.name
and k.id=o.parent_obj
and k.indid=i.indid
and c.id=o.parent_obj
and c.colid=k.colid
order by k.keyno
where o.xtype='PK'
and o.parent_obj=object_id('表名')
and i.id=o.parent_obj
and i.name=o.name
and k.id=o.parent_obj
and k.indid=i.indid
and c.id=o.parent_obj
and c.colid=k.colid
order by k.keyno
