The DROP DEFAULT command is utilized to remove a DEFAULT constraint.
To eliminate a DEFAULT constraint, execute the following SQL:
SQL Server / Oracle / MS Access:
ALTER TABLE Persons ALTER COLUMN City DROP DEFAULT; |
MySQL:
ALTER TABLE Persons ALTER City DROP DEFAULT; |