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.
Differences between temporary and permanent tables

Differences between temporary and permanent tables

Compared to permanent tables, temporary tables differ in these ways:

They have fewer types of constraints available.
They have fewer options that you can specify.
They are not visible to other users or sessions.
They do not appear in the system catalog tables.
They are not preserved, as described in the section Duration of temporary tables.

The INFO statement and the Info Menu option of DB-Access cannot reference temporary tables.