Professional Web Applications Themes

Perform cascade delete - Microsoft SQL / MS SQL Server

How can i performe a cascade delete in SQL2k? I have 2 child table for a master table and i want, when delete from the master, automatically delete all record related in the child. Now i delete first the record in the child DELETE FROM child1 WHERE IdDoc = IdDoc Delete from child2 where IdDoc=IdDoc and finally DELETE FROM Master WHERE IdDoc=idDoc There's another way to do this? thanks -- Posted via [url]http://dbforums.com[/url]...

  1. #1

    Default Perform cascade delete


    How can i performe a cascade delete in SQL2k?
    I have 2 child table for a master table and i want, when delete from the
    master, automatically delete all record related in the child.

    Now i delete first the record in the child

    DELETE FROM
    child1
    WHERE
    IdDoc = IdDoc

    Delete from
    child2
    where
    IdDoc=IdDoc

    and finally
    DELETE FROM
    Master
    WHERE
    IdDoc=idDoc

    There's another way to do this?

    thanks

    --
    Posted via [url]http://dbforums.com[/url]
    basidati Guest

  2. #2

    Default Re: Perform cascade delete

    How is your DDL designed? If you have references constraint set on child1 to
    child2 and to Master, you can use ON DELETE CASCADE option in your DDL. This
    will proactively implement the cascading deletes without much hazzles.

    --
    - Anith
    ( Please reply to newsgroups only )


    Anith Sen Guest

  3. #3

    Default Re: Perform cascade delete

    Thank you Anith,
    it works!

    --
    Direct access to this group with [url]http://web2news.com[/url]
    [url]http://web2news.com/?microsoft.public.sqlserver.programming[/url]
    basidati Guest

Similar Threads

  1. Dropdownlist Cascade
    By JimmyB4B in forum Macromedia Exchange Dreamweaver Extensions
    Replies: 1
    Last Post: December 18th, 04:50 AM
  2. possible to DELETE CASCADE?
    By Miles Keaton in forum PostgreSQL / PGSQL
    Replies: 5
    Last Post: December 30th, 10:42 PM
  3. A "cascade on delete" constraints deletes AFTER the source is gone??
    By Vitaly Belman in forum PostgreSQL / PGSQL
    Replies: 5
    Last Post: December 20th, 05:36 PM
  4. cascade update non-primary key field
    By Calvin in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 2nd, 01:37 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139