15.10 - Define Check Constraints - Teradata Administrator

Teradata Administrator User Guide

prodname
Teradata Administrator
vrm_release
15.10
category
User Guide
featnum
B035-2502-035K

Selecting Check from the Constraint button in the Create Table dialog box displays the Define Check Constraints dialog box.

Use the Define Check Constraints dialog box to define a Boolean condition Check constraints for the table.

 

Table 16: Define Check Constraints Dialog Box Description 

Field or Control

Description

Check

This list displays the name of each Check constraint specified for the table. Selecting a constraint in this list then displays its specifications in the Boolean Condition field.

Name

Use this field to specify an optional name for the Check constraint. The name specify is displayed in the checklist when the Add button is used to save your constraint specification.

Note: Constraint names are optional. If a name is not entered, Teradata Administrator displays UnNamed in this field and creates the table without a constraint name specification.

Boolean Condition

Use this field to enter the conditional expression for the Check constraint.