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!

Rename foreign key constraint

ruckanMar 12 2012 — edited Apr 3 2012
Hi,

I have table tbl_a with a column a_col1 referencing tbl_b.b_col1

I want to create the foreign key constraint name as FK_A_COL1 which is FK_<COLUMN NAME OF THE CHILD>.

Foreign Key Naming standards doesn't allow the use of child column name as part of the name.

Is there any other solution/script to achieve this?

Thanks.
This post has been answered by Philip Stoyanov-Oracle on Mar 30 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2012
Added on Mar 12 2012
#data-modeler
16 comments
8,120 views