Re: Kindly Help

maybe you need your key:

alter table childtab add constraint constr_names

    FOREIGN KEY (id_key)
    REFERENCES father_tab(id_key)
    ON DELETE CASCADE;
commit;

Steven wrote:

> 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.,

--

      Sebastian Bub
                           ''~``
                          ( o o )
+--------------------.oooO--(_)--Oooo.--------------------+
|                                                         |
|    http://oracle.bessy.de    mailto:bub@bii.bessy.de    |
|                                                         |
|    fon: +49 30 6392-4934     fax: +49 30 6392-4859      |
|                                                         |
|                     .oooO                               |
|                     (   )   Oooo.                       |
+----------------------\ (----(   )-----------------------+
                        \_)    ) /
                              (_/