Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
CREATE TEMP TABLE statementUse the CREATE TEMP TABLE statement to create a temporary table in the current database.

CREATE TEMP TABLE statement

Use the CREATE TEMP TABLE statement to create a temporary table in the current database.

Syntax

Notes:

¹ See Column definition
² See Multiple-Column Constraint Format
³ HCL OneDB™ extension
⁴ See Storage options for temporary tables
⁵ See LOCK MODE Options
⁶ See USING Access-Method Clause


Element	Description	Restrictions	Syntax
table	Name declared here for a table	Must be unique in session. See Declaring a name for a temporary table	Identifier

Usage

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.

If you include the optional IF NOT EXISTS keywords, the database server takes no action (rather than sending an exception to the application) if a temporary table of the specified name already exists in the current session.

You can also define indexes and constraints on temporary tables that you define with the CREATE TEMP TABLE statement.

In DB-Access, using the CREATE TEMP TABLE statement outside the CREATE SCHEMA statement generates warnings if you set DBANSIWARN.

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