Skip to Main Content
Forums

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!

SQL Data Modeler 17.4 default properties values (ie: set 'NOCACHE' on IDENTITY by default)

user12205052Feb 19 2018 — edited Feb 21 2018

Hi everyone,

I'm pretty new on SQL Data Modeler, and I was wondering if it is possible to define the default value of a specific property (Logical or Physical model) ?

My specific need is:

- When I create a new table on the logical model, and specify that my PK is Auto-Increment and Identity, i would like the IDENTITY DDL automatically generated has the 'CACHE' attribute set (instead of the default 'NOCACHE')

I know that i can manually change the value on each column of each table (see below picture), but I would like to avoid having to change this each time I create a new table ...

Identity Nocache.jpg

Thanks !
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 21 2018
Added on Feb 19 2018
6 comments
1,038 views