By default, when you create an in-memory table, the table is persistent. To create temporary or transient tables, use the keyword TEMPORARY or TRANSIENT. For more information, see Types of in-memory tables.
Use the following SQL statement to create a temporary table:
CREATE TEMPORARY TABLE <...>;
Use the following SQL statement to create a transient table:
CREATE TRANSIENT TABLE <...>;
In both cases, <...> denotes syntax that is the same as for any other type of table.
Temporary and transient tables are automatically stored in memory, even if you do not use the STORE MEMORY clause. If you use the STORE DISK clause, the server generates an error message.