Post reply

How to alter a non clustered primary key constraint to clustered

  • February 26, 2008 at 12:36 am

    #71328

    Hello,

    I've a table with primary key defined as non-clusterd, now without dropping it can I modify the existing index to clustered.

    Thanks in Advance,

    Rohit

  • February 26, 2008 at 12:48 pm

    #782197

    I do not think you can.

    In my memory, when you create a primary key first time, it will be clustered if there is no existing clustered index. Are you sure there is no clustered index in your table?

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

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