Depending on the type of DBMS, the following is generated regarding check constraints:
|
Database type |
Generation result |
|---|---|
|
Database does not support any check constraints |
No constraint is generated |
|
Database does not support multiple check constraints |
Constraint business rules, check parameters, and validation business rules are concatenated into a single constraint expression |
|
Database supports multiple check constraints |
First, the check parameters and validation business rules are generated into a single constraint, then the constraint business rules are generated into different constraints. Constraints are thus ordered |