On Thu, 23 Oct 1997, james.woodger wrote:
> 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").
CHECK constraints, because they are activated using the notation:
CREATE TABLE ...
(
SomeCol ...
CHECK (SomeCol IN ("Y", "N")) CONSTRAINT c1_xxxx
);
and appropriate variants on this notation.
> Other databases variously call these "rules", "check constraints", etc.
Yours,
Jonathan Leffler (johnl@informix.com) #include <witticism.h>