1
SELECT
COUNT
(
1
)
AS
Is_PK
2 FROM syscolumns
3 JOIN sysindexkeys
4 ON syscolumns.id = sysindexkeys.id AND syscolumns.colid = sysindexkeys.colid
5 JOIN sysindexes
6 ON syscolumns.id = sysindexes.id AND sysindexkeys.indid = sysindexes.indid
7 JOIN sysobjects
8 ON sysindexes.name = sysobjects.name AND sysobjects.xtype =
2 FROM syscolumns
3 JOIN sysindexkeys
4 ON syscolumns.id = sysindexkeys.id AND syscolumns.colid = sysindexkeys.colid
5 JOIN sysindexes
6 ON syscolumns.id = sysindexes.id AND sysindexkeys.indid = sysindexes.indid
7 JOIN sysobjects
8 ON sysindexes.name = sysobjects.name AND sysobjects.xtype =