DB2 Version 9.7 for Linux, UNIX, and Windows

Dropping primary keys

You can use the Control Center or the DROP statement to drop primary keys.

Procedure

To drop primary 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, select the primary keys to drop.
To drop a primary key using the command line, enter:
```
ALTER TABLE name
   DROP PRIMARY KEY
```

Results

When a foreign key constraint is dropped, packages or cached dynamic SQL statements containing the following might be marked as invalid:

Statements that insert or update the table containing the foreign key
Statements that update or delete the parent table.