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.
Single-Column Constraint Format

Single-Column Constraint Format

Use the single-column constraint format to create one or more data-integrity constraints for a single column in a temporary table.

Notes:

¹ HCL OneDB™ extension
² See CHECK Clause

This is a subset of the syntax of Single-Column Constraint Format that the CREATE TABLE statement supports.

You can find detailed discussions of specific constraints in these sections.

Constraint: For more information, see
CHECK: CHECK Clause
DISTINCT: Using UNIQUE or DISTINCT Constraints
NOT NULL: Using the NOT NULL Constraint
NULL: Using the NULL Constraint
PRIMARY KEY: Using the PRIMARY KEY Constraint
UNIQUE: Using UNIQUE or DISTINCT Constraints

Constraints that you define on temporary tables are always enabled.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.