drop default constraint in sql code example
Example 1: sql server drop constraint default value
ALTER TABLE [TheTable] DROP CONSTRAINT [TheDefaultConstraint]
Example 2: sql drop default
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;