Database Administration (MOSC)

MOSC Banner

Best Way to rename a foreign key

edited Apr 23, 2013 7:40AM in Database Administration (MOSC) 4 commentsAnswered ✓
Hi everyone

At my work i have the requirement to rename the foreign keys that do not meet the standards so that they do

I have created an script which renames the foreign key by first dropping it and the recreating it with the correct name.

Could there be any problems by the way i am doing it? or is there a better way to rename a foreign key instead of dropping it and recreating it.

Thanks for your help

Greetings

Mateo.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center