Re: [SQL] Doubts about FK

On Thu, Sep 18, 2008 at 5:49 AM, Rafael Domiciano <[EMAIL PROTECTED]> wrote: > 2008/9/12 Scott Marlowe <[EMAIL PROTECTED]> >> >> On Fri, Sep 12, 2008 at 12:14 PM, Rafael Domiciano >> <[EMAIL PROTECTED]> wrote: >> > Hi there, >> > >> > In my DB I have a couple of FK, so the change of referenced colu

Re: [SQL] Doubts about FK

2008/9/12 Scott Marlowe <[EMAIL PROTECTED]> > On Fri, Sep 12, 2008 at 12:14 PM, Rafael Domiciano > <[EMAIL PROTECTED]> wrote: > > Hi there, > > > > In my DB I have a couple of FK, so the change of referenced columns is a > > quite complicated. > > Today, I DISABLE TRIGGER ALL on the tables envolve

Re: [SQL] Doubts about FK

On Fri, Sep 12, 2008 at 12:14 PM, Rafael Domiciano <[EMAIL PROTECTED]> wrote: > Hi there, > > In my DB I have a couple of FK, so the change of referenced columns is a > quite complicated. > Today, I DISABLE TRIGGER ALL on the tables envolved and then ENABLE TRIGGER > ALL to back them. > Is there a

[SQL] Doubts about FK

Hi there, In my DB I have a couple of FK, so the change of referenced columns is a quite complicated. Today, I DISABLE TRIGGER ALL on the tables envolved and then ENABLE TRIGGER ALL to back them. Is there a better way to do that? I read something about SET CONSTRAINTS ALL DEFFERED, but I don't kn