怎样在MSSQL数据库中查到用户表的PK
---------------------------------------------------------------
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
把TrsNews改成你的表名，共有三处，TN_id改成你的字段名就行了。