Generating and running Alter DDL statements

To generate and run an Alter DDL statement

1. In the DB2 Navigator perspective, select one of the supported objects:

   • Databases
   • Indexes
   • Procedures
   • Storage Groups
   • Tables
   • Table Spaces

   For more information, see Navigating-to-an-object.

2. On the Tasks toolbar, click Alter .

   Tip

   You can also right-click on the object and select Alter from the menu.

   An Alter editor view is displayed in the Schema Management perspective.

3. Make any needed changes to the editable properties.

   Important

   You can also use additional displayed panels to change the properties of the object's subelements, such as table columns or index partitions.

   When you change a property, the name of the changed property field is italicized.

4. Click Generate alter DDL .The DDL is displayed in the Alter DDL tab.
5. (Optional) Enter an alternative SQLID in Current SQLID to set the SQL authorization ID for the command.

6. Click Run DDL  to run the DDL statement.

   Tip

   The editable properties are disabled when you return to the editor tabs. To make more changes, click Refresh alter editor  to reload the object definition and continue.