Mega Code Archive
CHECK Clause
<![CDATA[
[CONSTRAINT c_name]
CHECK [NOT FOR REPLICATION] expression
expression must evaluate to a Boolean value (TRUE or FALSE)
11> CREATE TABLE customer
12> (cust_no INTEGER NOT NULL,
13> cust_group CHAR(3) NULL,
14> CHECK (cust_group IN ('c1', 'c2', 'c10')))
15> GO
1>
2> drop table customer;
3> GO
]]>