Oracle Database Discussions

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!

Drop foreign key constraint without giving name of the constraint

misterimranMar 21 2005 — edited Mar 21 2005

Hi Guys,

We can drop primary key constraint in a table with this SQL command>
ALter table fina_year drop primary key cascade
/

Is there any way to drop a foreign key constraint without specifing the name of the constraint. As the name of the constraint might be different if the same user exist in 2 different databases. How to write a generic code for deleting a foreign key without specifying name.

Regards,

Imran Baig

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 18 2005

Added on Mar 21 2005

#general-database-discussions

3 comments

1,814 views