Results 1 to 4 of 4

Thread: Cascade delete

  1. #1
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441

    Unanswered: Cascade delete

    I am trying to cascade delete something;

    Code:
    delete from x where q_id=3
    table x has referentail integrety constraints on y and z

    table z has referentail integrety constraints on a

    I want the delete statment to remove all related records. Is it possible?

  2. #2
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    No one knows??


  3. #3
    Join Date
    Oct 2003
    Posts
    33
    simply add "ON DELETE CASCADE" into your constraints definitions

  4. #4
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    I found that afterwards, but then found out that ALTER CONSTRAINT is in the developers "to do" list...great.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •