To drop relationships on columns in a table in the current location:
- Click
SQL for DB2
on the
Tools menu;
then click
SQL Wizard.
- If the Catalog Browser window is not open, click
to open it.
- On the Catalog Browser window, ensure the
Table tab is selected.
- Click the table you want.
- Click
Alter.
- Select the name of the foreign key you want to drop from the list.
- In the
Relationships group, click
Drop.
- Click
OK to close the Alter Table window.