Misunderstanding of SQL Server clustered index and primary key

Many people may confuse PrimaryKey with clustered index, or think this is the same thing. This concept is very incorrect. A primary key is a constraint attached to an index. This index can be a clustered index or a non-clustered index. So on one (or a group) Field

Many people may confuse Primary Key with clustered index, or think this is the same thing. This concept is very incorrect. A primary key is a constraint attached to an index. This index can be a clustered index or a non-clustered index. So on one (or a group) Field

Misunderstanding of SQL Server clustered index and primary key

Many people may mix the Primary Key and clustered index, or think this is the same thing. This concept is very incorrect.

A primary key is a constraint attached to an index. This index can be a clustered index or a non-clustered index.

Therefore, if a primary key or server space exists on one (or a group) field, it indicates that it has an index, server space, and Vm, but not necessarily a clustered index.

For example:

# TempPKCL 4 () # tempPKNCL13 ()