Column Definition

Use the Column Definition segment of CREATE Temporary TABLE to list the name, data type, default value, and constraints of a single column.

Column Definition:
 
                         (1)
|--column--| Data Type |-------+-------------------------+------>
                               |                    (2)  |
                               '-| DEFAULT Clause |------'
 
>--+------------------------------------------+-----------------|
   |                                     (3)  |
   '-| Single-Column Constraint Format |------'
 

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

This portion of the CREATE Temporary TABLE statement is almost identical to the corresponding section in the CREATE TABLE statement. The difference is that fewer types of constraints are allowed in a temporary table.