MySQL Tutorial MySQL Advanced MySQL Database Account Management MySQL References
MySQL Tutorial MySQL Advanced MySQL Database Account Management MySQL References

MySQL DROP DEFAULT Keyword

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

DROP DEFAULT constraint

To drop DEFAULT constraint from City column of Employee table, the following statement can be used:

ALTER TABLE Employee
ALTER City DROP DEFAULT;

OR

ALTER TABLE Employee
ALTER COLUMN City DROP DEFAULT;

❮ MySQL Keywords
AlphaCodingSkills
AlphaCodingSkills Android App
Facebook Page Twitter Page LinkedIn Page
Learning Tutorials
Learning Tutorials
Useful Links
Python Libraries
About Us  |  Privacy Policy  |  Contact Us
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.