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)

        ALTER TABLE DEPTTBL
          MODIFY ADMDEPT CHAR(3)
          MODIFY DEPTNAME CHAR(30)