15.00 - CHECK 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)

CHECK Constraint Attributes

The following table lists the attributes reported as the result of a HELP CONSTRAINT request for a check 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 check constraints, the value is CHECK.

Constraint

VARCHAR(255)

No

The text of the constraint clause,

Dictionary Name

VARCHAR(128)

No

The attributes shown in this section are derived from and supersede the corresponding older Name attribute, while providing additional functionality.

The Name attribute is 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