是的, Server: Msg 5074, Level 16, State 1, Line 1 The object 'DF__pass__classage__1DE57479' is dependent on column 'classage'. Server: Msg 4922, Level 16, State 1, Line 1 ALTER TABLE DROP COLUMN classage failed because one or more objects access this column.我是这样执行的:alter table pass drop column classage
這是因為classage這個列上有一個約束DF__pass__classage__1DE57479該約束有可能是是主鍵,外鍵或是default值.先drop掉該約束: alter table TableName drop DF__pass__classage__1DE57479;然後drop掉classage列: alter table TableName drop column classage;
報什麼錯?
Server: Msg 5074, Level 16, State 1, Line 1
The object 'DF__pass__classage__1DE57479' is dependent on column 'classage'.
Server: Msg 4922, Level 16, State 1, Line 1
ALTER TABLE DROP COLUMN classage failed because one or more objects access this column.我是这样执行的:alter table pass drop column classage
alter table TableName drop DF__pass__classage__1DE57479;然後drop掉classage列:
alter table TableName drop column classage;
create table aa
(
a1 int,
a2 varchar(20) default '12345'
);這樣在a2上面就有一個約束是關於default值的.