How to drop primary key referenced to other foreign key?

[Rohullah]

Hello
I want to Drop a primary key Referenced to other foriegn key.
I try the following method
---------------------
alter table Stock drop constraint SYS_C005460;
---------------------
But it give me The following Message.

ORA-02273: this unique/primary key is referenced by some foreign keys.

How to drop it PLZ gime the Best Answer.
Lookin forword,Thank you in Advance.

[Oralloy]

You'll have to find all foreign key references to the primary key of your table, and drop them or modify them.

I think you'll find a table in the catalog with all key references identified in it, if you are having difficulty finding the tables that you need to change.

Regardless, why do you need to drop the constraint? Are you trying to perform a change, which will violate or destroy your data integrity? Make sure before you go down the path of forcing this issue. That's what Oracle's error message is trying to tell you.

[magic wand]

alter table Stock drop constraint SYS_C005460 CASCADE;