主键信息

[kongooo]

怎么查主键对应的是哪个列

[zhouhaihe]

选中表右键选设计表就可以看到

[syf1125]

select * from sysobjects o, sysindexes i where o.id = i.id and o.name = 'tablename'

[chuifengde]

sp_pkeys '表名'

[lizhongheng]

sp_pkeys

[kongooo]

to syf1125
运行结果中哪个值是主键对应的列ID啊。

[kongooo]

to syf1125
运行结果中哪个值是主键对应的列ID啊。

[kongooo]

to syf1125
运行结果中哪个值是主键对应的列ID啊。

[中国风]

declare @Obj_ID int
set @Obj_ID=object_id('表名')
  select name from syscolumns where id=@Obj_ID and colid in(
   select colid from sysindexkeys where @Obj_ID=id and indid in(
    select indid from sysindexes where @Obj_ID=id and name in(
     select name from sysobjects where xtype='PK' and parent_obj=@Obj_ID
   )))