sql 2000 determine primary key from system table列出所有primary key select object_name(a.[id]) as [tablename] ,object_name(a.constid) as [pk_name] ,b.[name] as [pk_column] from sysconstraints a inner join syscolumns b on a.[colid]+1 = b.[c
sql 2000 determine primary key from system table列出所有primary key
select object_name(a.[id]) as [tablename]
,object_name(a.constid) as [pk_name]
,b.[name] as [pk_column]
from sysconstraints a inner join syscolumns b
on a.[colid]+1 = b.[colid] and a.[id] = b.[id]
where a.status = 2593
ps. status=2593还未找到确认的文件说明,另外覆合key可能不适用