Example: CHECK Constraints - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530
CREATE TABLE stats_tbl
   (Id INTEGER
   ,Gender CHAR(1)
   ,EdLev  INTEGER
   ,CHECK (Gender = 'F' OR Gender = 'M')
   ,CHECK ((EdLev >= 0) AND (EdLev <= 22)));