Check Constraints

Toad Data Modeler
1

Hi,

In a Logical Model, I can define valid values for a table attribute.
When converted to Physical model, this creates a constraint with SQL script.
It would be helpful if TDM used %ColumnName% instead of the actual column name, so the constraint would still work if the column is renamed in the physical model.

Also being able to specify the constraint name would be helpful to prevent duplicate constraint names in the final DDL script (e.g. ValidValuesBAND_INDEX is being used used in different tables that have BAND_INDEX).

Regards
Malcolm

2

Hello Malcolm,

Thanks for your suggestion, we will see what we can do about it. Thanks. CR # 60 632.

Regards,

Vladka