获取主键约束名:
方法一:
SELECT TABLE_NAME, COLUMN_NAME, constraint_name
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE TABLE_NAME='表名'
方法二:
SELECT A.NAME AS 表名,B.NAME AS 主键名
FROM SYSOBJECTS A JOIN SYSOBJECTS B
ON A.ID=B.PARENT_OBJ AND A.XTYPE='U' AND B.XTYPE='PK'
WHERE A.NAME='表名'
方法三:
use msdb
go
EXEC sp_pkeys @table_name = N'backupset',@table_owner = N'dbo';
---------------------------------------------------------------------------
获取外键约束名:
SELECT object_name(constid) AS 外键约束名, object_name(fkeyid) as 外键表名, object_name(rkeyid) as 主键表名
FROM sysreferences
WHERE object_name(fkeyid)='表名'
获取 某个表 的 主键名
最新推荐文章于 2022-02-19 21:57:08 发布