Re: please help

Hi,

Try this:

alter table <child table> add constraint <constraint name> foreign key(<child table columns>)
references <parent table>[(<parent table columns>)] on delete cascade;

Andrew Protasov

> hi,
>
> l have two exiting Parent and Child tables.
>
> May l know what's the actual command for me to use at SQL
> worksheet,
> in order to make them "on cascade delete" ?
>
> Purpose: when l deleted the parent table's record, the child
> table's record
> will be deleted as well.
>
>
>
> --
> With regards
> Steven
>
> Steven Koh, Internet Software Engineer,
> Mediaworks, Pacific Internet Pte. Ltd.,
>
>
>
>
Received on Tue Dec 15 1998 - 02:29:30 CST