Restriction: This topic applies to Windows environments only.
To change relationships on columns in a table in the current location:
- From the main menu, click
Run > Tools > Data Tools > SQL Option for DB2 > Client > 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 alter from the list.
- In the
Relationships group, click
Alter.
- Make the changes you require.
- 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.
- Click
OK to close the Alter Table window.