SqlServer 获取表主键的方法

select COL_NAME(object_id('表名'),c.colid)
from sysobjects a,sysindexes b,sysindexkeys c
where a.name=b.name and b.id=c.id and b.indid=c.indid
and a.xtype='PK' and a.parent_obj=object_id('表名')
and c.id=object_id('表名')

 

posted @ 2013-10-05 14:27  逍遥子k  阅读(1371)  评论(0编辑  收藏  举报