解决SQL Server删除字段报错The object ‘DF__CompanyTr__Creat__0CDAE408’ is dependent on column ‘Created’.
问题描述
当我试图删除一个含有默认值得字段时
ALTER TABLE CompanyTransactions DROP COLUMN Created
报错如下:
Msg 5074, Level 16, State 1, Line 2
The object ‘DF__CompanyTr__Creat__0CDAE408’ is dependent on column ‘Created’.
Msg 4922, Level 16, State 9, Line 2
ALTER TABLE DROP COL
原创
2020-07-20 16:43:54 ·
7455 阅读 ·
1 评论