Skip to Content

 

  

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see ALTER and BMC AMI Change Manager for Db2 13.1.

DROP FOREIGN KEY statement

The DROP FOREIGN KEY statement removes a referential integrity constraint from a table.

GUID-FE7254D1-3DAC-4275-9629-B2D301E3CB93-low.png

DROP FOREIGN KEY tableOwner 1.tableName 1.constraintName

This option specifies the fully qualified name of the constraint to be dropped.

REFERENCETB tableOwner 2.tableName 2

This option specifies the name of the table to which the foreign key references.

KEYCOLUMNS ( columnName, ...)

This option specifies the list of columns that the foreign key references.

REFCOLUMNS ( columnName, ...)

This option specifies the names of the parent key columns.


Related topic

CDL-statements




 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

ALTER and BMC AMI Change Manager for Db2 12.1