Skip to Main Content

APEX

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!

How to drop FOREIGN KEY

415083Mar 11 2004 — edited Mar 16 2004
Hi,

I have tried to delete only FOREIGN KEY constraint but I cannot because there is no FKs are listed on 'Drop Constraint' option on 'Manage Table' wizard in SQL Workshop. Do I need to use 'Drop Table' and check 'Cascade Constraints?' even when I want to delete only FKs?

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 13 2004
Added on Mar 11 2004
2 comments
395 views