PostgreSQL Tutorial

PostgreSQL Advanced

PostgreSQL Database

Account Management

PostgreSQL References

PostgreSQL Tutorial

PostgreSQL Advanced

PostgreSQL Database

Account Management

PostgreSQL References

PostgreSQL DROP DEFAULT Keyword

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

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