首页 > itarticle > sqlserver 删除依赖

sqlserver 删除依赖

admin 11月 12, 2020 0

遇到的问题

ALTER TABLE DROP COLUMN Areas failed because one or more objects access this column.
Msg 5074, Level 16, State 1.
The object ‘DFVoucherTyAreas__6748398C’ is dependent on column ‘Areas’. (Line 7)

CMD

1	ALTER TABLE Customer DROP CONSTRAINT Con_First;

eg.

1	alter table vouchertype drop consTRAINT DF__VoucherTy__Areas__6748398C;