Post reply

Logical cascade constraint

  • March 15, 2012 at 6:11 am

    #252626

    Hi,

    I have around 53 tables in my schema. Due to some business constraint , we have not implement on delete cascade constraint on all entities.

    Now I am finding a way where I can do so with Tsql rather to enable cascade delete on all relations.

    Is this can be accomplish with TSQL ?

  • March 15, 2012 at 6:23 am

    #1459770

    thbaig1 (3/15/2012)

    Hi,

    I have around 53 tables in my schema. Due to some business constraint , we have not implement on delete cascade constraint on all entities.

    Now I am finding a way where I can do so with Tsql rather to enable cascade delete on all relations.

    Is this can be accomplish with TSQL ?

    Yes, this can be done with TSQL.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • March 15, 2012 at 7:09 am

    #1459811

    thank you Ten Centuries

    but how ?any TSQl code reference you have ?

  • March 15, 2012 at 7:21 am

    #1459820

    thbaig1 (3/15/2012)

    thank you Ten Centuries

    but how ?any TSQl code reference you have ?

    I knew that "how?" question will follow...

    In order to provide "any TSQl code reference" we have, we will need

    a bit more details about what exactly you have and want?

    Please follow the link at the bottom of my signature, to find out how to provide details for a question to get relevant answers...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

Viewing 4 posts - 1 through 4 (of 4 total)

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy