Toad World® Forums

Creating Primary Key indexes

Hallo !

We found the following problem or requirement:
Until now, we used erwin for modelling.
There we didn’t need to explicitely specify indexes for the pk of each table,
they were defined automatically and had the option for “generate yes/no”.

Now, as we have imported our modell to toad, we look for the same functionality.
Is there any solution to autocrreate the indexes or maybe there is a script, which accomplishes this task ?

Thanks for your help,
Reiner.

Hi,

TDM works in a different way. When you mark attribute as PK, new key appears on tab Keys on Entity properties dialog. Parameters then can be defined on Key properties dialog. See attachments.

If you still need to create index to primary key, you/we can write a macro that would add indexes to selected tables. Note: indexes equoally named to primary keys (with no specifically defined properties) will not be loaded during reverse engineering. Only indexes that are somehow specific are loaded, otherwise TDM works with keys (AFAIK keys were not managed separately in ERWin. TDM works with keys and I believe it simplifies development a little).

Regards,

Vaclav

Hi,

TDM works in a different way. When you mark attribute as PK, new key appears on tab Keys on Entity properties dialog. Parameters then can be defined on Key properties dialog. See attachments.

If you still need to create index to primary key, you/we can write a macro that would add indexes to selected tables. Note: indexes equoally named to primary keys (with no specifically defined properties) will not be loaded during reverse engineering. Only indexes that are somehow specific are loaded, otherwise TDM works with keys (AFAIK keys were not managed separately in ERWin. TDM works with keys and I believe it simplifies development a little).

Regards,

Vaclav