begin
for r in ( select table_name, constraint_name
from user_constraints
where constraint_type = 'R' )
loop
execute immediate 'alter table '||r.table_name
||' drop constraint '||r.constraint_name;
end loop;
end loop;
terça-feira, 1 de novembro de 2016
Oracle - drop table constraints without dropping tables
Fonte: http://stackoverflow.com/questions/3701233/oracle-drop-table-constraints-without-dropping-tables
Assinar:
Postar comentários (Atom)
Nenhum comentário:
Postar um comentário