skip to main content
Supported SQL Statements and Extensions : Alter Table : Altering a Local Table : Drop Clause: Constraints
  

Try DataDirect Drivers Now
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