Change the length of a varchar column

You can use the ALTER table command to change the length of a varchar column. You can increase the length of a varchar column to a maximum size of 64,000.

To change the length of a varchar column, enter:

   MYDB.SCHEMA(USER)=> ALTER TABLE t3 MODIFY COLUMN (col1 VARCHAR(6));