sql drop default
snippet in sql

sql server drop constraint default value

user2820

ALTER TABLE [TheTable] DROP CONSTRAINT [TheDefaultConstraint]

sql drop default

user4411

Removes a default value for a column.
Example (MySQL): Removes the default value from the ‘name’ column in
the ‘products’ table.
ALTER TABLE products
ALTER COLUMN name DROP DEFAULT;