求SQL Server查询关系表主键的代码,如关系表名为TABLE,查询该关系表的主键,代码怎么写?
------解决方案--------------------
SELECT *
FROM sys.key_constraints
WHERE type = 'PK' AND parent_object_id=OBJECT_ID('dbo.TABLE');
试试
SELECT *
FROM sys.key_constraints
WHERE type = 'PK' AND parent_object_id=OBJECT_ID('dbo.TABLE');