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