Search CTRL + K

Primary Key

#CS/Database

在 关系型数据库 中，主键 唯一标识表中某一 行。

主键 是符合业务场景下的某一个 候选键。

CMU 15-445

A relation's primary key uniquely identifies a single tuple.[1]

Database System Concepts

We shall use the term primary key to denote a candidate key that is chosen by the database designer as the principal means of identifying tuples within a relation.[2]

  1. https://youtu.be/uikbtpVZS2s?t=2085 ↩︎

  2. Abraham Silberschatz, Henry F. Korth, and S. Sudarshan, Database System Concepts, Seventh edition (New York, NY: McGraw-Hill, 2020). P44 ↩︎