====== Conditional Check Constraint ======

<sxh sql>
ALTER TABLE table1 ADD CONSTRAINT table1_conditional
CHECK(
  (field1 = 1 AND field3 IN ('MIHAEL', 'MICHAEL')) OR
  (field1 = 2 AND field3 IN ('MIHAIL', 'MIKAEL'))
);
</sxh>

{{tag>sql}}