Before you start, ensure that the current location is set to the location where the table resides.
- 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 to alter.
- Click
Alter.
- Change the column definitions, indexes, keys and relationships as required.
You can look at the SQL statements that will be used to make your changes by clicking
SQL at any time.
- Click
OK.
Note: XDB databases support extensive alterations to a table, even if it contains data. DB2 databases support a much more restricted set of alterations. If the target database is a DB2 database, unsupported options are not available on the Alter Table window.
