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可能不適用
? 版權聲明
文章版權歸作者所有，未經允許請勿轉載。
THE END
