Example: Changing the data size of a column

Nonstop Database, HiRDB Version 9 System Operation Guide

This example changes the definition size of the DATA01 column in the TABLE01 table from VARCHAR(150) to VARCHAR(200).

Organization of this subsection: (1) Use the ALTER TABLE statement to change the definition of column DATA01

 
ALTER TABLE TABLE01 CHANGE DATA01 VARCHAR(200);