16.10 - Example: CHECK Constraints - Teradata Database

Teradata Database SQL Data Types and Literals

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Programming Reference
featnum
B035-1143-161K
   CREATE TABLE stats_tbl
      (Id INTEGER
      ,Sex CHAR(1)
      ,EdLev INTEGER
      ,CHECK (Sex = 'F' OR Sex = 'M')
      ,CHECK ((EdLev >= 0) AND (EdLev <= 22)));