Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Mar 15, 2013 1:50 PM by
Surrogate Key Generation using Database Design Transformer
Mar 15, 2013 1:50 PM
I am using Oracle Designer 9 (188.8.131.52.10). When generating tables from the ERD, Database Design Creates surrogate keys afor all tables or for none of them. Is it possible:
1- to have better control and choose the ones that should get surrogate keys?
2- to replace the suffix "_ID" with another one (for instance, have it generate using the suffix "_KEY")?
3- use a glossary of abbreviations such that long words be consistently abbreviated?
This content has been marked as final.
Show 0 replies