主键何处寻？

[wjflover]

各位大侠情况是这样的：我知道一个数据表的名字，想得到它的主键是由那些字段构成的，不知道应该从哪个系统表中来找啊？

[Ivony]

syscolumns和sysobjects

[gOODiDEA]

select a.name FROM syscolumns a inner join sysobjects b on a.id=b.id and b.xtype='U' and b.name<>'dtproperties' where exists(SELECT 1 FROM sysobjects where xtype='PK' and name in ( SELECT name FROM sysindexes WHERE indid in( SELECT indid FROM sysindexkeys WHERE id = a.id AND colid=a.colid ))) and b.name='"+ tableName +"'