Dropping foreign keys - IBM DB2 9.7 for Linux, UNIX, and Windows

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:
1. Expand the object tree until you see the Tables folder.
2. Right-click the table you want to modify, and select Alter from the pop-up menu.
3. On the Keys page, click Add.
4. 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