Recently I had to drop some foreign key constraints on tables.
Below the SQL, which did the job for me. After 'drop constraint' you have to provide the name of a constraint you want to delete as it is maintained in table all_constraints.
Alter Table
a_table
drop constraint
fk_any_table_ref;
