Post reply

Duplicates

  • March 24, 2010 at 9:56 am

    #139948

    Does clustered index automatically creates a primary key on the column?

    Will that column allow duplicates?

  • March 24, 2010 at 10:02 am

    #1139030

    A clustered index does not create a primary key on a table. However on the right column it accomplishes the same tasks.

    A clustered index does not have to be unique.

    Note: this is readily seen from the SSMS create index GUI.

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

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