>>-CREATE--+-TEMP-----------+--TABLE--table--------------------->
           |  (1)           |
           '--------SCRATCH-'
 
>--| Table Definition |----------------------------------------><
 
Table Definition:
 
      .-,--------------------------.
      V                       (2)  |
|--(----| Column Definition |------+--+-----------------------------------------------------------+--)-->
                                      |      .-,----------------------------------------------.   |
                                      |      V                                         (3)    |   |
                                      '-,------+-| Multiple-Column Constraint Format |------+-+---'
                                               |                       (2)                  |
                                               '-| Column Definition |----------------------'
 
                                (4)
>--+-------------+--| Options |---------------------------------|
   '-WITH NO LOG-'
 

1. Extended Parallel Server only
2. See page CREATE Temporary TABLE
3. See page Multiple-Column Constraint Format
4. See page Temporary Table Options

You must have the Connect privilege on the database to create a temporary table. The temporary table is visible only to the user who created it.

In DB–Access, using the CREATE Temporary Table statement outside the CREATE SCHEMA statement generates warnings if you set DBANSIWARN.

In ESQL/C, the CREATE Temporary TABLE statement generates warnings if you use the -ansi flag or set the DBANSIWARN environment variable.