Script to drop all constraints on s user tables?
Hi!
Im trying to create a simple script that drops the constraints for a user:
select 'alter table user1.'||table_name|| 'drop constraint' ||constraint_name|| from dba_tables where...
But Im stuck. How do I join dba_tables with dba_constraints?
Regards
U
Im trying to create a simple script that drops the constraints for a user:
select 'alter table user1.'||table_name|| 'drop constraint' ||constraint_name|| from dba_tables where...
But Im stuck. How do I join dba_tables with dba_constraints?
Regards
U
0