SQL Language Guide > SQL Language Guide > SQL Statements > CREATE TRANSIENT TABLE
Was this helpful?
CREATE TRANSIENT TABLE
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The CREATE TRANSIENT TABLE statement creates a transient table.
This statement has the following format:
CREATE TRANSIENT TABLE [IF NOT EXISTS] [schema.] tablename
(column_specification {, column_specification })
[table_constraint {, table_constraint}]
[AS subselect]
[WITH with_clause]
IF NOT EXISTS
Creates the transient table only if it does not already exist in the database. It does not perform any action if the table already exists.
Note:  Use this option with caution. The table definition of a pre-existing transient table may differ from the CREATE TRANSIENT TABLE IF NOT EXISTS statement.
table_name
Specifies the name of the new transient table. It must be a valid object name.
column_specification
Specifies the characteristics of the column, as described in Column Specification.
Note:  For Analytics Engine tables, defaults, nullability, and identity columns work only for INSERT...VALUE, not INSERT SELECTs.
subselect
Specifies the nested SELECT statement.
with_clause
Specifies the following WITH clause option:
STRUCTURE=
Defines the storage structure of the transient table. Valid values are:
• X100 (Default): Stores data in columns and puts as few columns as possible in one disk block. The alias for X100 is VECTORWISE.
• X100_ROW: Stores data in rows and puts as many columns as possible in one disk block. The alias for X00_ROW is VECTORWISE_ROW.
PARTITION=(partitioning_scheme) | [NOPARTITION]
Specifies how a transient table is to be partitioned. For details, see Partitioning Schemes for Transient Tables.
Last modified date: 09/11/2026