Identity in a Domain

Toad Data Modeler
1

Hi,

I’ve created a Domain called “Identity” for my SQL Server 2008 Model. It is an Integer with the Identity option checked.

Of course I use this for Primary Keys in my system.

When I create relationships, the foreign keys still have the Identity option checked.

Is there any way to have this unchecked in Foreign Keys?

Thanks,
Jay

2

Hi Jay again,

We recommend not to use Identities in domain.

but just one link makes it for you:

http://modeling.inside.quest.com/entry.jspa?externalID=1311&categoryID=35

Cheers,
Lukas

3

Thanks…that will work.

Jay

4

You’re welcome.

Regards,
Lukas

5

Hi there,

I have the same problem here. I tried running the script, but as you can see in the attached image, I get an error with a message "Object doesn't support this property or method" in line 11 (I guess it refers to Attr.PKForeignKeys.count).

I'm totally new to TDM, so I have no idea of how to fix this. Any help will be welcome!

Thanks,

Dario.

script_error.jpeg
script_error.jpeg827×398 35.2 KB

6

Hi Dario,

from the screenshot I can’t see any problem but the script should work, we have just tried it again. If you want, you can send the model in which you experience the issue to us to modeling@quest.com and we will check it for you.

Regards,
Lukas

Btw. What version of TMD are you using?

Message was edited by: dkretek

7

Hi,

it’s change request CR 88396.

Regards,
Lukas