Post reply

Delete

  • May 4, 2007 at 12:09 pm

    #370979

    how can I delete a record when that is referenced by some other table. I just delete all records where ever that is referenced.

    what i mean is when i delete a row all the child rows related to tht field shud also delete.

  • May 4, 2007 at 12:12 pm

    #704438

    Ok..I think I ahve to use CASCADE option on delete

  • May 4, 2007 at 12:44 pm

    #704450

    Yes, if you created Froeign Keys they have to have the CASCADE ON DELETE option turned on for you to get this to happen. If you don't have Foreign Keys constraints defien you can delete and nothing will happen in the children.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply