Changing the Definition of a Database Table 

Prerequisites

You need to have the necessary user authorizations and the NOT EXCLUSIVE user attribute.

For an explanation of user authorizations and user attributes, see the Database Users section of the Concepts of the Database System documentation and the Authorization section of the SQL Reference Manual.

Procedure

...

       1.      Select the table and choose Catalog Manager ® Alter Table.
A window for defining tables opens.

       2.      Make the required changes:

Define columns

Define column constraints

Define foreign key dependencies

Define miscellaneous information

       3.      Choose Table Definition ® Alter Table.

To export the SQL statement for changing the database table to the SQL dialog, choose Table Definition ® Export to SQL Dialog.

For information on the syntax of ALTER TABLE statements, see the ALTER TABLE Statement section of the SQL Reference Manual.