Post reply

delete query

  • February 11, 2011 at 3:09 am

    #245105

    I HAVE QUERY REGARDING DELETE

    THERE ARE TWO TABLES

    T1 AND T2

    I WANT DELETE PARTICULAR DATA FROM TABLE 1 SAY NAME . TABLE 2 IS REFERS TO TABLE 1 WITH SOME FOREIGN KEY CONSTRAINT.

    HOW CAN I GO AHEAD. CAN ANY BODY GIVE ME CLUE HOW IT IS DONE AND IF POSSIBLE PLEASE SEND ME SAMPLE CODE

    THANKS

    PRAVEEN

  • February 11, 2011 at 3:27 am

    #1285586

    Is there any predefined plan about what you want to do with Table2 rows which are linking to deleted row from Table1. Do you want these rows in Table2 be deleted or updated?

  • February 11, 2011 at 3:35 am

    #1285588

    YES I WANT TO DELETE OR UPDATE ROWS FROM TABLE 2 ALSO

    THANKS

  • February 11, 2011 at 3:44 am

    #1285590

    If you are happy to delete rows in both the table, then you can go with cascading delete.

  • February 13, 2011 at 4:59 am

    #1286131

    IF you could send me sample script would appreciate that.(cascade delete)

  • February 13, 2011 at 5:53 am

    #1286136

    duplicate post. No replies please.

    Discussion already started here.

    @praveen: I asked you before not to yell at us. All it does is limiting the replies you might get.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 6 posts - 1 through 5 (of 5 total)

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