To change the structure of a table

Restriction: This topic applies to Windows environments only.

Before you start, ensure that the current location is set to the location where the table resides.

  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 to alter.
  5. Click Alter.
  6. 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.

  7. 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.
Parent topic: Manage Databases