救急啊,菜鳥有個簡單的問題需各位幫忙,解決立馬把分捧上,在線等
我在存儲過程中有一個語句為 alter table mytable add col1 float not null default 0
直接用alter table mytable drop column col1會出現錯誤
Server: Msg 5074, Level 16, State 1, Line 1
The object 'DF__ppayment__col1__1328BA3B' is dependent on column 'col1'.
Server: Msg 4922, Level 16, State 1, Line 1
ALTER TABLE DROP COLUMN col1 failed because one or more objects access this column.
怎麼樣在存儲過程中將col1刪除,一定要寫在存儲過程中,希望各位幫忙,謝了