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('表名')
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('表名')
转载于:https://www.cnblogs.com/xyz0835/p/3352385.html