SQL Tutorial

SQL Advanced

SQL Database

SQL References

SQL Tutorial

SQL Advanced

SQL Database

SQL References

SQL DROP DEFAULT Keyword

The SQL DROP DEFAULT keyword is used to delete a DEFAULT CONSTRAINT.

DROP DEFAULT constraint

To drop DEFAULT constraint from City column of Employee table, the SQL code is given below:

MySQL

ALTER TABLE Employee
ALTER City DROP DEFAULT;

OR

ALTER TABLE Employee
ALTER COLUMN City DROP DEFAULT;

SQL Server

/* Drops a DEFAULT constraint named DV_City */
ALTER TABLE Employee
DROP CONSTRAINT DV_City;

Oracle

ALTER TABLE Employee 
MODIFY City DEFAULT NULL;

❮ SQL Keywords

AlphaCodingSkills

AlphaCodingSkills Android App

AlphaCodingSkills is a online learning portal that provides tutorials on Python, Java, C++, C, C#, PHP, R, Ruby, Rust, Scala, Swift, Perl, SQL, Data Structures and Algorithms. Tutorials, examples, references and content of the website are reviewed and simplified continuously to improve comprehensibility and eliminate any possible error. We use cookies to ensure best browsing experience on our website. While using this website, you acknowledge to have read and accepted our cookie and privacy policy.