22,209
社区成员
发帖
与我相关
我的任务
分享
4、然后把isnew1改名为isnew
修改列名对相关约束名称没有影响,举个例子,下面语句修改列前后对应的默认约束名称没有变化:ALTER TABLE testdt ADD dt INT NOT NULL DEFAULT(0) WITH VALUES GO SELECT dc.name FROM sys.default_constraints AS dc WHERE dc.parent_object_id=OBJECT_ID('testdt') AND dc.[type]='D' AND COL_NAME(dc.parent_object_id,dc.parent_column_id)='dt' GO sp_rename 'testdt.dt','dt1','COLUMN' GO SELECT dc.name FROM sys.default_constraints AS dc WHERE dc.parent_object_id=OBJECT_ID('testdt') AND dc.[type]='D' AND COL_NAME(dc.parent_object_id,dc.parent_column_id)='dt1'
你如何修改的列名?执行了的具体sql语句贴出来看一下, 约束的内容,你可以在ssms中右点击,查看
ALTER TABLE testdt ADD dt INT NOT NULL DEFAULT(0) WITH VALUES
GO
SELECT dc.name
FROM sys.default_constraints AS dc
WHERE dc.parent_object_id=OBJECT_ID('testdt') AND dc.[type]='D' AND COL_NAME(dc.parent_object_id,dc.parent_column_id)='dt'
GO
sp_rename 'testdt.dt','dt1','COLUMN'
GO
SELECT dc.name
FROM sys.default_constraints AS dc
WHERE dc.parent_object_id=OBJECT_ID('testdt') AND dc.[type]='D' AND COL_NAME(dc.parent_object_id,dc.parent_column_id)='dt1'