Toad World® Forums

Application Variable UniqueNumber


#1

Hello
I’m doing some tests with version 4 Beta.

I wanted to know how the variable in question. I used the name of a checkconstraint (Example: _C0) but if there are 2 checkconstraint on the same table is always generated the same name.

Can you tell me how to solve this problem in another way?

Thank you

Message was edited by: a339466_656


#2

Hi,

click Settings | Default values and in section Entities | Check Constraints click the Name value and change it to the following:
<%OwnerName%>_C0<%UniqueNumber%>

Then restart TDM and try to create new check constraints.

To the problem: please make sure the <%UniqueNumber%> system variable is the ending item and there is nothing else, no space, no character etc.

Regards,

Vaclav