This shows you the differences between two versions of the page.
— |
conditional_check_constraint [2019/01/30 15:39] (current) mihael created |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== 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}} |