DROP FOREIGN KEY Clause

Description

You can drop a foreign key constraint defined for a table using the DROP FOREIGN KEY clause.

Syntax

ALTER [ TABLE | CLASS ] table_name DROP FOREIGN KEY constraint_name

Example

ALTER TABLE a_tbl DROP FOREIGN KEY fk_a_tbl_id;