Re: Another Terminlogy Question
Check constraints.
From the 7.2 Syntax guide (p 1-173):
CREATE TABLE acct_chk ( .........
credit_amt MONEY CHECK (credit_amt BETWEEN 0 and 99999))
You want ..... IN ('Y', 'N') ......
--
Sky
+------( southwel@smtpgw.maricopa.gov )------+- Maricopa County -+
| Schuyler L. Southwell | Attorney's Office |
| Data Management Consultant | 301 W. Jefferson |
| Voice: 602-506-8107 **** FAX: 602-506-3970 | Phoenix, AZ 85003 |
+--------------------------------------------+-------------------+
>>> james.woodger <jwoodger@sympatico.ca> 10/23 6:28 AM >>>
What does Informix call the constraints that let you define a hard-coded list of values that a column must have (e.g. "Y", "N").
Other databases variously call these "rules", "check constraints", etc.
!