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.
Single-Column Constraint Format
Notes:
- 1 HCL OneDB™ extension
- 2 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.