By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table strumenti(id int primary key, name varchar2(75));
create table disegnare
(
id int primary key,
code_strumenti int,
constraint fk_str_code foreign key(code_strumenti) references strumenti(id)
);
select * from user_constraints where constraint_type = 'R';
| OWNER | CONSTRAINT_NAME | CONSTRAINT_TYPE | TABLE_NAME | SEARCH_CONDITION | R_OWNER | R_CONSTRAINT_NAME | DELETE_RULE | STATUS | DEFERRABLE | DEFERRED | VALIDATED | GENERATED | BAD | RELY | LAST_CHANGE | INDEX_OWNER | INDEX_NAME | INVALID | VIEW_RELATED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FIDDLE_CSVSGTIGHVWDPYCZKBVR | FK_STR_CODE | R | DISEGNARE | null | FIDDLE_CSVSGTIGHVWDPYCZKBVR | SYS_C00269701 | NO ACTION | ENABLED | NOT DEFERRABLE | IMMEDIATE | VALIDATED | USER NAME | null | null | 13-NOV-19 | null | null | null | null |
BEGIN
FOR c IN
(select *
from user_constraints
where table_name = 'DISEGNARE' and constraint_type = 'R')
LOOP
execute immediate 'alter table '||c.table_name||' drop constraint '||c.constraint_name;
END LOOP;
END;
/
1 rows affected
select * from user_constraints where constraint_type = 'R';