sql-server - `primary key`关键字与SQL Server中的聚集索引有何关系？

Question

PRIMARY KEY关键字与SQL Server中的聚集索引有何关系？

(有些人似乎想回答这个问题，而不是a different question I asked，所以我为他们提供了一个更好的答案。)

Answer 1

表的聚集索引通常在主键列上定义。

但是，这不是严格的要求。

从MSDN:

When you create a PRIMARY KEY constraint, a unique clustered index on the column or columns is automatically created if a clustered index on the table does not already exist and you do not specify a unique nonclustered index.

和:

You can create a clustered index on a column other than primary key column if a nonclustered primary key constraint was specified.