Why is Check constraints only on tables and not on Columns or even Domains?

Hi Roy,

Not all database platforms that we support allow for the type of constraint creation that you describe. SQL Server supports the binding of rules on columns and user defined datatypes but the feature is in maintenance mode. The usage of check constraints is endorsed.

To keep the transformation from the platform-independent model to the the rdbms-specific scripts consistent we've chosen the most broadly supported feature for these kind of data integrity checks.

Table check constraints should be automatically created based on settings defined on the domain level in the Software Factory. One setting may affect many tables this way. It should not limit developers in any way that this feature is implemented using table check constraints.

However, if there are functional aspects that you'd like to see improved when it comes to data integrity checks, we'd love to hear this.

Thanks Anne,

Seems logical.

I am wondering if it could be possible to define a constraint on domain in TSF and on deployment transfer them to the table (for those databases that don't support them at domain level)? In this way it is possible to define the constraint once and use them for all columns that make use of that domain.

This reduces the chance of human-error (which I'm bound to make ;-) ) when changing one and missing another.

The SQL-expression based constraints could be added at domain-level, feel free to add an idea in the ideation section.

Do keep in mind that the expressions are allowed to use other columns, potentially limiting the useage of a domain to tables with certain columns present.

In the meanwhile, it's possible to use the dynamic model to automatically add constraints to all columns using a certain domain.