8 Replies Latest reply on Apr 30, 2014 10:12 AM by sql_coder

    Turn Non Unique Index into a Unique Index




      Version: Enterprise Edition


      We got a non unique Index for a primary key constraint. I would like to change that into a unique index. I know you cannot alter the index to change it. Is the only way to disable the primary key, drop the index and enable the constraint again or is there a better solution? It is a 24/7 platform.