Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

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

  • table_name : Specifies the name of a table whose constraint is to be deleted.
  • constraint_name : Specifies the name of foreign key constraint to be deleted.
Example

ALTER TABLE a_tbl DROP FOREIGN KEY fk_a_tbl_id;