Article
home/blog/Loading

Alter a table droping a columns default value

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;