Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Naming Standards for Unique Constraints and Indexes not working

OraTechAficionadoMay 7 2015 — edited May 8 2015

I found yet another Naming Standards Issue

I'm trying to create both a unique constraint as well as a regular index via Unique Constraints and Indexes in Table Properties with the assumption it will use the Design Properties Templates. It doesn't.

Naming Standard Template.jpg

As noted from the Template image above, my Unique Constraint template is {table}_{column}_UK

and my Index template is {table}_{column}_IDX. Yet, when I attempt to create the Unique Constraint, it creates the naming convention as CUSTOMER_ADDRESS__UK (2 underscores??) as noted below.

Table_Props_Unique_Constraint.jpg

My assumption was that it needed a column so I added the column and also applied the Naming Rules - nothing.

Table_Props_Unique_Constraint_w_Column.jpg

Is my assumption incorrect about these Constraints being named via the templates? If not, what does Naming Rules do in this context?

The same behavior is evident when attempting to create Indexes.

I'm not getting any feedback on my posts. Are these bugs or just user error?

This post has been answered by Philip Stoyanov-Oracle on May 8 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 5 2015
Added on May 7 2015
2 comments
1,239 views