Articles
sql
Alter a table droping a columns default valuesql

To drop a default value from a column you need to alter the column and DROP DEFAULT

Drop default value example

ALTER TABLE table_name
    ALTER COLUMN column_name DROP DEFAULT;