Referential Constraint Attributes - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
imq1591724555718.ditamap
dita:ditavalPath
imq1591724555718.ditaval
dita:id
B035-1184
lifecycle
previous
Product Category
Teradata Vantage™

The following table lists the attributes reported as the result of a HELP CONSTRAINT request for a referential constraint.

Attribute Data Type Nullable Description
Name VARCHAR (30) No The name of the constraint about which HELP information is being reported.
Type VARCHAR(15) No The type of constraint. For referential constraints, the value is REFERENCE.
State CHAR(12) No Identifies any inconsistencies in the parent-child relationship defined in the constraint.
If the State Text is:
  • INCONSISTENT, then the constraint is inconsistent.
  • INVALID, then the constraint is not valid.
  • UNRESOLVED, then the constraint is Unresolved.
  • VALID, then the constraint is valid.
The following additional values may be returned if Batch or Soft RI are used:
  • InconsisBatch
  • InvalidBatch
  • UnresolvBatch
  • ValidBatch
  • InconsisSoft
  • InvalidSoft
  • UnresolvSoft
  • ValidSoft
Index Id SMALLINT No Internal identifier for the index assigned by the system, which implements unique constraints as indexes.
Foreign Key Columns VARCHAR(512) Yes Lists the names of the foreign key columns for the constraint.
The system converts each column name, including substitution characters, to its full length. If the constructed list of column names exceeds the maximum length of the Column Names field, the list is truncated after the last comma separator that can fit within the field.
Parent Database Name VARCHAR (30) Yes The name of the database that contains the parent table for the constraint.
Parent Table Name VARCHAR (30) Yes The name of the table that contains the constraint.
Parent Index ID

(except if the State is UNRESOLVED)

SMALLINT Yes Identifies the parent index for the constraint.
Parent Key Columns VARCHAR(512) Yes Lists the names of the parent key columns for the constraint.
The system converts each column name, including substitution characters, to its full length. If the constructed list of column names exceeds the maximum length of the Column Names field, the list is truncated after the last comma separator that can fit within the field.
Dictionary Name VARCHAR(128) No The attributes shown in this section are derived from and supersede the corresponding older Name, Parent DB, and Parent Table attributes, while providing additional functionality.

The older attributes are retained for compatibility with existing applications.

For details on the new attributes, see the topics beginning with Object Name and Title Data in HELP Reports.

SQL Name VARCHAR(644)
UEscape VARCHAR(1) Yes
Parent DB Dictionary Name VARCHAR(128) No
Parent DB SQL Name VARCHAR(644)
Parent DB UEscape VARCHAR(1) Yes
Parent Table Dictionary Name VARCHAR(128) No
Parent Table SQL Name VARCHAR(644)
Parent Table UEscape VARCHAR(1) Yes