Toad World® Forums

Unique Names for Oracle Check Constraints


#1

Is there a way to get TDM to automatically generate unique names for oracle check constraints?

Is there a way to use application variables in naming conventions? I would like to be able to use UniqueNumber in particular.

The rename check constraint macro is useless to me because resets the numbering for every table. I have a column that appears by the same name in every table, and the macro ends up generating duplicate names.

Message was edited by: mary.stamper_062


#2

Hi,

naming conventions cannot be used for that purpose. I see two possibilities how to get correct model.

You can either run the macro on selected tables only, or run verification and take advantage of Quick Fixes (this is my preferred solution).

Regards,

Vaclav