Re: Disable all constraints and triggers in entire schema.

On Nov 13, 4:17 pm, Sean Nakasone <seannakas..._at_yahoo.com> wrote:
> Is there a way to disable all contraints and triggers in all the tables in
> a particular schema? Either through toad or sql.

begin
  for rec in (select * from user_constraints) loop     execute immediate 'alter table ' || rec.table_name || ' disable constraint ' || rec.constraint_name;
  end loop;
end;
/ Received on Wed Nov 14 2007 - 18:26:20 CST