My fault. I should have first asked if you had a foreign key defined at all.
"Nick" <aroughguy_at_nsp.toughguy.net> wrote in message
news:1G7x9.23452$Sr6.690602_at_ozemail.com.au...
> Exactly!
>
> I did a search through 1000+ page thick SQL manual but I could find only
> DELETE CASCADE and SET NULL
> hence the question.
>
>
> "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
> news:5qr7sugc4tshs8afvdod2mfi43h27nt07n_at_4ax.com...
> > On Sun, 3 Nov 2002 01:31:41 +1100, "Nick" <aroughguy_at_nsp.toughguy.net>
> > wrote:
> >
> > >I don't know I can do that
> > >How would the syntax be like?
> > >Thanks
> >
> >
> > delete restrict is the default.
> >
> > Other than that mere syntax questions are best answered by yourself by
> > looking it up in the sql reference manual.
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
>
>
Received on Mon Nov 04 2002 - 08:58:14 CST
