User Guide > User Guide > Using Transient Tables > Syntax for Defining a Transient Table
Was this helpful?
Syntax for Defining a Transient Table
The syntax for defining a transient table is as follows:
CREATE TRANSIENT TABLE [IF NOT EXISTS] [schema.] tablename
(column_specification {, column_specification })
[table_constraint {, table_constraint}]
[AS subselect]
[WITH with_clause]
For details, see CREATE TRANSIENT TABLE.
Last modified date: 09/11/2026