Unnamed constraints are not assigned system-generated names.
- constraint_name
- Optional name for a constraint.
- For information about naming database objects, see Teradata Vantage™ - SQL Fundamentals, B035-1141.
- The CONSTRAINT constraint_name specification is mandatory for named constraints for UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK when those constraints are named, and applies to column-level and table-level constraints.
- It does not apply to row-level security constraints. See row_level_security_constraint_name CONSTRAINT later in this table.
- Constraint names must conform to the rules for Vantage object names and be unique among all other constraint, primary index, and secondary index names specified in the table definition. For a description of Vantage identifiers and a list of the characters they can contain, see Teradata Vantage™ - SQL Fundamentals, B035-1141.
- See Teradata Vantage™ - Temporal Table Support, B035-1182 and Teradata Vantage™ - ANSI Temporal Table Support, B035-1186 for information about the constraints that can be defined for temporal tables.