I saw couple threads where Vladka explained that domain check constraints can’t have names. I understand that the same domain can be used for multiple field but check constraint can use table name + field name + domain constraint name as a check constraint name or any similar combinations.
Our database has > 100 “boolean” fields having 2 values ‘Y’ and ‘N’. We describe it as one Boolean domain with check constrain rule:
%ColumnName% in (‘Y’, ‘N’)
And I don’t want to have hundreds system generated check constraint names.
So TDM can generate check constraint name like tablename_column_name_Boolean-check.
Is it reasonable? Or there is better way to do it?
We run version 3.4 , maybe similar idea is implemented in newer versions?