CHECK constraints


When a null field is encountered during a CHECK constraint clause, the row is discarded. To prevent this, qualify the CHECK constraint with OR field IS NULL.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*