Drop constraint or change column?
The solution proposed don't drop the constraint but modify the default from null to not null. Isn't correct the statement:
"alter table companies
alter headquarters_phone_number drop default;" ?
1 answers ( 0 marked as helpful)
alter headquarter_phone_number drop default 0 ;
This query would be correct. since we have set the default value to 0.