DROP FOREIGN KEY statement
The DROP FOREIGN KEY statement removes a referential integrity constraint from a table.
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
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*