DB2 Version 9.7 for Linux, UNIX, and Windows

Changing column properties

Use the ALTER TABLE statement to change column properties, such as nullability, LOB options, scope, constraints and compression attributes, data types and so forth. For complete details, see the ALTER TABLE statement.

About this task

For example, from the command line, enter:

   ALTER TABLE EMPLOYEE
      ALTER COLUMN WORKDEPT
         SET DEFAULT '123'

Before you begin

To alter a table, you must have at least one of the following privileges on the table to be altered:

ALTER privilege
CONTROL privilege
DBADM authority
ALTERIN privilege on the schema of the table

To change the definition of a existing column, to edit and test SQL when changing table columns, or to validate related objects when changing table columns, you must have DBADM authority.