27,579
社区成员
发帖
与我相关
我的任务
分享
if exists(SELECT 1
FROM sys.tables t
INNER JOIN sys.columns c ON t.object_id = c.object_id
INNER JOIN sys.default_constraints dc ON c.default_object_id = dc.object_id
WHERE t.name = '你的表名称'
AND c.name = '你的列名称')
存在默认值约束的处理
else
不存在默认值约束的处理
SELECT t.name ,
c.name AS column_name ,
c.default_object_id,
dc.name as default_constraint_name
FROM sys.tables t
INNER JOIN sys.columns c ON t.object_id = c.object_id
INNER JOIN sys.default_constraints dc ON c.default_object_id = dc.object_id
WHERE t.name = '你的表名称'
AND c.name = '你的列名称'
SELECT default_object_id FROM sys.columns
WHERE object_id = OBJECT_ID('表名')
AND nam = '字段名'