> Or I can do that only if I specify when the foreign key is created.

"SQL novice" <balacr@gmail.com> wrote in message
news:1132299915.134325.257320@g44g2000cwa.googlegroups.com...
>I have a master table and a child table. I have created a foreignkey
> constraint on the child table with OUT the ON DELETE CASCADE option.
>
> Now when I delete records from the Master table, can I specify "on
> delete cascade" at that time.
> Or I can do that only if I specify when the foreign key is created.
>
> Thanks in advance.
>