15.10 - Example: Adding an Unnamed CHECK Constraint - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Add an unnamed CHECK constraint to ensure that values in column column_2 are always greater than 100:

     ALTER TABLE table_1 ADD CHECK (column_2 > 100);