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.
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.