15.00 - Referential Constraint Attributes - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Referential Constraint Attributes

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.

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

    Note: 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 “Working with Object Name and Title Data in HELP Reports” on page 896.

    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