简单的问题，sqlserver中的主键列信息存在哪个系统表呀、

[eastpond]

如题

[qinyu199903]

sysobjects

[pengdali]

想查询某一个表有那些字段，如何知道那一个字段是该表的主键
---------------------------------------------------------------
if(

SELECT count(*)
FROM sysobjects
WHERE (name =
(SELECT name
FROM sysindexes
WHERE (id = OBJECT_ID('TrsNews')) AND (indid =
(SELECT indid
FROM sysindexkeys
WHERE (id = OBJECT_ID('TrsNews')) AND (colid =
(SELECT colid
FROM syscolumns
WHERE (id = OBJECT_ID('TrsNews')) AND (name = 'TN_id'))))))) AND
(xtype = 'PK')

)>0
bgein
print '是主键'
end

[pengdali]

select rtrim(b.name) as colname
,case when h.id is not null then 'PK' else '' end as primarykey
,type_name(b.xusertype) + case when b.colstat & 1 = 1 then '[ID(' + convert(varchar,ident_seed(a.name)) + ',' + convert(varchar,ident_incr(a.name)) + ')]' else '' end as type
,b.length
,case b.isnullable when 0 then 'N' else 'Y' end as [isnull]
,isnull(e.text,'') as [default]
,isnull(c.value,'') as descript
from sysobjects a,syscolumns b
left outer join sysproperties c on b.id = c.id and b.colid = c.smallid
left outer join syscomments e on b.cdefault = e.id
left outer join (select g.id,g.colid from sysindexes f,sysindexkeys g where f.id = g.id and f.indid = g.indid and f.indid > 0 and f.indid < 255 and (f.status & 2048)<>0) h on b.id = h.id and b.colid = h.colid
where a.id = b.id
and a.id = object_id('titles') --tablename改成你要导出的表的名称
order by b.colid

[eastpond]

谢谢大力