Re: How to disable constraint

cyril wrote:

> Hello,
> How to disable all foreign constraints in a table with a single SQL order ?
>
> sample : 'alter table mytable disable constraint all'
>
> thanks

Can not be done. They can be deferred in a single statement but not disabled.

Which is good because it keep people from doing it so readily.

The fact that you can do something doesn't mean you should.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)