Usage and Examples of SQL DROP DEFAULT Keyword

SQL Keyword Reference

DROP DEFAULT (Delete DEFAULT)

The DROP DEFAULT command is used to delete the DEFAULT constraint.

To delete the 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;

SQL Keyword Reference