DROP DEFAULT
The DROP DEFAULT command is used to delete a DEFAULT constraint.
To drop a DEFAULT constraint, use the following SQL:
SQL Server / Oracle / MS Access:
ALTER TABLE Persons
ALTER COLUMN City DROP DEFAULT;
Tag: sql drop default constraint if exists
SQL DEFAULT Constraint
SQL DEFAULT Constraint
The DEFAULT constraint is used to set a default value for a column.
The default value will be added to all new records, if no other value is specified.
SQL DEFAULT on CREATE TABLE
The following SQL sets a DEFAULT value for the “City” column when the “Persons” table is created: Continue reading SQL DEFAULT Constraint