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改成你的字段名就行了。
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改成你的字段名就行了。
和FK的sql command
呵呵