You can use the Control Center or the DROP statement to
drop foreign keys.
About this task
Procedure
To drop foreign keys using the Control Center:
Expand the object tree until you see the Tables folder.
Right-click the table you want to modify, and select Alter from
the pop-up menu.
On the Keys page, click Add.
Select the foreign keys at right to drop.
To drop foreign keys using the command line, enter:
ALTER TABLE name
DROP FOREIGN KEY foreign_key_name
Example
The following examples use the DROP PRIMARY KEY and DROP
FOREIGN KEY clauses in the ALTER TABLE statement to drop primary keys
and foreign keys on a table:
ALTER TABLE EMP_ACT
DROP PRIMARY KEY
DROP FOREIGN KEY ACT_EMP_REF
DROP FOREIGN KEY ACT_PROJ_REF
ALTER TABLE PROJECT
DROP PRIMARY KEY