Dropping Constraint in SQL

sqlWe 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}