Toad World® Forums

A gallery of Attributes with NotNull constraint name post defined


#1

Hi,

My goal is to set in a Gallery a set of attributes where the NotNull constraint name is defined based on the table name and the attribute name.
For example
If I drag and drop an attribute INSID to a table TEST then the NotNull constraint name should be NN_TEST_INSID.

Is it possible to set in a gallery attributes where the NotNull Constraint name uses Application Variables?
For example:NN__

Sebastien


#2

Hi,

unfortunately not. See
http://modeling.inside.quest.com/thread.jspa?messageID=140724&#140724

The fastest solution would be a macro that will add correcly named attribute with constraint to your table. But in case you modify name of the attribute, name of the constraint will have to be modified either manually or using another macro.

Regards,

Vaclav


#3

Thanks for your reply.

Would you have such a macro?

Sebastien


#4

Hi,

I think you can customize the macro at:
http://modeling.inside.quest.com/entry.jspa?externalID=5101&categoryID=34

And we have a script that renames NN constraints here:
http://modeling.inside.quest.com/entry.jspa?externalID=1361&categoryID=35

Regards,

Vaclav

Message was edited by: vaclav