select * from employees

alter table employees add jobid int default 0
update employees set jobid =0

alter table employees drop constraint DF__employees__deliv__5006DFF2

alter table employees drop column delivery

alter table employees drop constraint  DF__employees__miter__50FB042B

alter table employees drop column miter

alter table orders add mndobid int default 0

update orders set mndobid=0

