Nonstop Database, HiRDB Version 9 System Operation Guide

[Contents][Index][Back][Next]

13.6.2 Example 1: Adding a column to a table without the FIX attribute

This example adds a column (C4) to a table without the FIX attribute (TABLE01).

[Figure]

Organization of this subsection
(1) Use ALTER TABLE to add column C4

(1) Use ALTER TABLE to add column C4

 
ALTER TABLE TABLE01 ADD C4 INTEGER;
 

In this case, the null value is stored in column C4.