Post reply

Modify a Unique key

  • October 1, 2012 at 2:37 pm

    #263081

    We have a unique key on 4 columns of a table. I also see there is also a non clustered index created for it.

    Now I would like to add one more column for the key and index, how can I do that from both UI and T_SQL?

    Thanks

  • October 1, 2012 at 2:48 pm

    #1544147

    Drop the unique key/index.

    Add the new column.

    Create a new Unique Index on the now 5 columns.

  • October 1, 2012 at 2:50 pm

    #1544148

    Thanks, got it.

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

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