• PK by default creates a unique clustered index if one doesn't already exists.

    If a clusterd index already exists, you can specify NON CLUSTERED clause to create a noon clustered index.

    Thank You,

    Best Regards.

    SQLBuddy