Forum Stats

  • 3,770,705 Users
  • 2,253,155 Discussions
  • 7,875,553 Comments

Discussions

Categories

Generating FK index, PK index and Unique constraint index

user11377561
user11377561 Member Posts: 18
edited Apr 2, 2013 11:58AM in SQL Developer Data Modeler Discussions
Under preferences, DDL, I have Automatic Index Generation setup for primary, foreign key and unique constraint. SDDM is generating these automatically in the DDL with the name of the FK having an X at the end of it. e.g., if the name of the fk is <aaaa>FK1, it is generating the index name as <aaaa>FK1X. Is this default behavior? Is there a way to specify a template for the automatic generation of this index (i.e., I would like to generate the index with the same name as the FK itself without the X at the end of the index name).

Please advise how this can be done.

Thanks!
Tagged:
· Share on TwitterShare on Facebook

Answers

  • Kent Graziano
    Kent Graziano Member Posts: 471
    In the newest version (3.3) go to Tools -> Preferences -> Data Model -> Naming Standards - Templates. There is an option for Automatic Index. Default is <constraint>_IX. Just change that and drop/change the IX.
    · Share on TwitterShare on Facebook
  • user11377561
    user11377561 Member Posts: 18
    Kent,

    Thanks for your response. The template you are referring to gets used when we explicitly define a regular index in the table properties window and we are OK with IX in this case. However, in the case of automatically generating indexes in the DDL for primary key, foreign key, unique constraints (without having to explicitly define such indexes in the table properties window), we would like such indexes generated in the DDL with the same name as the foreign key, primary key or unique constraint without the X at the end of it (i.e., <aaa>FK foreign key should also automatically generate <aaa>_FK index in the DDL). Currently, SSDm is generating these automatically with the X at the end of the name of the corresponding unique constraint, primary key, foreign key. Hope this helps clarify the question we have.

    Please advise if this is possible to be configured in SDDM.

    Thanks!
    · Share on TwitterShare on Facebook
  • Kent Graziano
    Kent Graziano Member Posts: 471
    What is the full version number that you are using?
    · Share on TwitterShare on Facebook
  • Philip Stoyanov-Oracle
    Philip Stoyanov-Oracle Member Posts: 3,354 Employee
    Hi,
    However, in the case of automatically generating indexes in the DDL for primary key, foreign key, unique constraints (without having to explicitly define such indexes in the table properties window), we would like such indexes generated in the DDL with the same name as the >foreign key, primary key or unique constraint without the X at the end of it (i.e., <aaa>FK foreign key should also automatically generate <aaa>FK index in the DDL)
    As Kent wrote you need the latest version of Data Modeler - 3.3.0.747 and there is a template called "Automatic Index" - it's default value is *{constraint}_IX* , you can change it to *{constraint}* and you'll get the job done. That template is used when such indexes are generated.

    Philip
    · Share on TwitterShare on Facebook
  • user11377561
    user11377561 Member Posts: 18
    Thanks, Kent and Philip.

    We will upgrade the version we use here currently.
    · Share on TwitterShare on Facebook
This discussion has been closed.