Adding Synonym when generating script for a table in design Editor
Hi ,
I am new to oracle designer ,Could someone please answer my following queries in relation to Design Editor,
1. Each time i generate script for a newly defined table through Generate( of Design Editor) , i have to manually select the corresponding synonym from the "objects" tab "dont'Generate" and move to "generate".Is there any setting by which the script for synonym is generated by default without manaully selecting them .
2. I need to define naming standards for the FK constraints ,something like R_XXXX where XXXX is a number which will be incremented sequencialy.Do we have any setups?
Please help...
Thanks,
Vips