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;

Copyright 1999-2023 by Refsnes Data. All Rights Reserved.