15.00 - CHECK Constraint Attributes - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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