Last answered:

18 Nov 2022

Posted on:

04 Dec 2021


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)
Posted on:

18 Nov 2022


alter headquarter_phone_number drop default 0 ;

This query would be correct. since we have set the default value to 0.

Submit an answer