MariaDB Tutorial MariaDB Advanced MariaDB Database Account Management MariaDB References
MariaDB Tutorial MariaDB Advanced MariaDB Database Account Management MariaDB References

MariaDB DROP DEFAULT Keyword

The MariaDB 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;

❮ MariaDB 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.