To drop relationships

Restriction: This topic applies to Windows environments only.

To drop relationships on columns in a table in the current location:

  1. From the main menu, click Run > Tools > Data Tools > SQL Option for DB2 > Client > SQL Wizard.
  2. If the Catalog Browser window is not open, click * to open it.
  3. On the Catalog Browser window, ensure the Table tab is selected.
  4. Click the table you want.
  5. Click Alter.
  6. Select the name of the foreign key you want to drop from the list.
  7. In the Relationships group, click Drop.
  8. Click OK to close the Alter Table window.
Parent topic: Manage Databases