To change relationships

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

1. Click SQL for DB2 on the Tools menu; then click 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 alter from the list.
7. In the Relationships group, click Alter.
8. Make the changes you require.
9. When you have finished, click OK to close the Alter Relationship dialog box.

   You can look at the SQL statements that will be used to make your changes by clicking SQL.

10. Click OK to close the Alter Table window.