Use the CREATE TEMP TABLE statement to create a temporary table in
the current database.
>>-CREATE--TEMP--TABLE--table--| Table Definition |------------><
Table Definition:
.-,--------------------------.
V (1) | (3)
|----(----| Column Definition |------+--+------------------------------------------------+--)--| Options |--------->
| .-,---------------------------------------. |
| V (2) | |
'-,----+-| Multiple-Column Constraint |------+-+-'
| (1) |
'-| Column Definition |---------------'
>--+-------------+----------------------------------------------|
'-WITH NO LOG-'
Notes:
- See page CREATE Temporary TABLE
- See page Multiple-Column Constraint Format
- See page Temporary Table Options
| Element |
Description |
Restrictions |
Syntax |
| table |
Name declared here for a temporary table |
Must be unique among the names of temporary tables in the
same session |
Identifier, p. Identifier |
The CREATE TEMP TABLE statement is a special case of the CREATE Temporary
TABLE statement. The CREATE Temporary TABLE statement can also create a SCRATCH
table in an Extended Parallel Server database.
For the complete syntax and semantics of the CREATE TEMP TABLE statement,
see CREATE Temporary TABLE .