Dropping Constraint in SQL

We have seen in previous tutorials how to add constraints like FOREIGN KEY and DEFAULT.  But in case, you no longer need them, then you can easily drop them using DROP CONSTRAINT statement.  The syntax for dropping a constraint is given below.

ALTER TABLE {Table_Name}
DROP CONSTRAINT {Constraint_Name}

You May Also Like:

Default Constraint in SQL Foreign Key Constraint in SQL Creating, Altering, & Deleting Database in SQL SELECT Statement in SQL DELETE Statement in SQL