Drop Clause: Constraints
Purpose
Use the Drop clause to drop a constraint from an existing table. It is optional.
Syntax
DROP {[CONSTRAINT] constraint_name}
where:
constraint_name
specifies an existing constraint.
Notes
The specified constraint cannot be a primary key constraint or unique constraint.
Example A
This example drops the test_fk constraint.
ALTER TABLE test DROP CONSTRAINT test_fk
