Toad World® Forums

Identity in a Domain

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

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

Thanks…that will work.

Jay

You’re welcome.

Regards,
Lukas

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.

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

Hi,

it’s change request CR 88396.

Regards,
Lukas