How to drop a foreign key

I have a table A which contains a foreign key reference to table B's primary key, e.g.:

create table A (
...

  fid varchar2(16) not null,
...

  foreign key (fid) references B(pid) on delete cascade )

where pid is the primary key of the table B.

Can someone tell me how to drop (or disable) the foreign key in table A.

Thanks

david Received on Tue Apr 10 2001 - 23:06:34 CDT