To delete a constraint using SQL, use the ALTER TABLE...DROP CONSTRAINT statement. When you drop a constraint, you must specify RESTRICT. RESTRICT aborts the operation if there are any constraints that depend on the constraint being dropped.