Post reply

Disable constraints

  • April 16, 2012 at 5:02 am

    #149195

    Hi,

    A unique constraint automatically creates an index.

    What happens with the index if the unique constraint is disables ?

    Is it dropped ?

  • April 16, 2012 at 7:10 am

    #1474007

    1. Create a table

    2. Create an unique constraint

    3. Check what is created (sp_help)

    4. Drop unique constraint

    5. Check what is left (again sp_help)

    You will find the answer and prove it with own experience!

    _____________________________________________
    "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 2 posts - 1 through 1 (of 1 total)

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