Use the ADD Column clause to add a column to a table.

ADD Column Clause:
 
             .-,--------------.
             V                |
|--ADD--+-(----| New Column |-+--)-+----------------------------|
        '-| New Column |-----------'
 
New Column:
 
                             (1)
|--new_column--| Data Type |------------------------------------>
 
>--+-------------------------+---------------------------------->
   |                    (2)  |
   '-| DEFAULT Clause |------'
 
>--+------------------------------------------+----------------->
   |                                     (3)  |
   '-| Single-Column Constraint Format |------'
 
>--+----------------+-------------------------------------------|
   '-BEFORE--column-'
 

1. See page Data Type
2. See page DEFAULT Clause
3. See page Single-Column Constraint Format

Element	Description	Restrictions	Syntax
column	Name of column before which new_column is to be placed	Must already exist in the table	Identifier, p. Identifier
new_column	Name of column that you are adding	You cannot add a serial column if the table contains data	Identifier, p. Identifier

The following restrictions apply to the ADD clause:

• You cannot add a serial column to a table that contains data.
• In Extended Parallel Server, you cannot add a column to a table that has a bit-mapped index.
• You cannot add columns beyond the maximum row size of 32,767 bytes.

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]