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 3 (of 3 total)

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