SQL Statements › ALTER TABLE › Processing › Example 2

Example 2

Modify two columns to allow for more character data than previously defined.

1. Table name: DEPTTBL
2. Column names: ADMDEPT (to be 3 characters) and DEPTNAME (to be 30 characters)

    EXEC SQL
         ALTER TABLE DEPTTBL
           MODIFY ADMDEPT CHAR(3)
           MODIFY DEPTNAME CHAR(30)
    END-EXEC