17.00 - Example: Adding a Column With an Unnamed CHECK Constraint - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
September 2020
Content Type
Programming Reference
Publication ID
English (United States)

Add an unnamed CHECK constraint to ensure that values in column column_1 are always greater than 0.

This example is valid only if there is not an existing unnamed column level CHECK for column_1 in table_1.

     ALTER TABLE table_1 ADD CONSTRAINT column_1 CHECK (column_1 > 0);