Post reply

Are primary keys clustered indices by default?

  • September 22, 2006 at 3:51 pm

    #174238

    Are primary keys clustered indices by default?

     

    Thanks

  • September 22, 2006 at 4:06 pm

    #662048

    When you create a PRIMARY KEY constraint, a unique index on the column, or columns, is automatically created. By default, this index is clustered; however, you can specify a nonclustered index when you create the constraint.

    -- From BOL

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

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