Essential Books

Drop Constraint

suggest change 
ALTER TABLE Employees 
DROP CONSTRAINT DefaultSalary

This Drops a constraint called DefaultSalary from the employees table definition.

Note:- Ensure that constraints of the column are dropped before dropping a column.

Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

ALTER TABLE:
*ALTER TABLE
*Add Columns
*Drop Column
*Add Primary Key
*Drop Constraint
*Alter Column
*Add Constraint
Table Of Contents