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 TABLE statementUse the CREATE TABLE statement to create a new permanent table in the current database.
Column definitionUse the column definition segment of the CREATE TABLE statement to declare the name and data type (and optionally the default value and the constraints or the security label) of a single column of the new table.
Single-Column Constraint FormatUse the Single-Column Constraint format to define and declare the name of at least one constraint on a single column, and to specify the mode of each constraint.
Restrictions on Using the Single-Column Constraint Format

Restrictions on Using the Single-Column Constraint Format

The single-column constraint format cannot specify a constraint that involves more than one column. Thus, you cannot use the single-column constraint format to define a composite key. For information on multiple-column constraints, see Multiple-Column Constraint Format.

You cannot define a referential constraint or a unique constraint on any column of a RAW table. Only NOT NULL or NULL constraints are supported on RAW tables.

You cannot place unique, primary-key, or referential constraints on BLOB, BYTE, CLOB, or TEXT columns. You can, however, check for NULL or non-NULL values on BYTE or TEXT columns with a check constraint.

If the constraint is on a column that stores encrypted data, HCL OneDB™ cannot enforce the constraint.