SQL•SQL References

SQL DROP DEFAULT Keyword

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;

MySQL

ALTER TABLE Persons
ALTER City DROP DEFAULT;

Loading lesson path

SQL•SQL References

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;

MySQL

ALTER TABLE Persons
ALTER City DROP DEFAULT;