Databasesbeginner1 min read

Primary Key

N/A

主键

Primary Key · N/A · 主键 · PRYE-mair-ee kee · PK · unique key · Databases · sql · schema · identityDatabasesPK unique key

/PRYE-mair-ee kee/

Also known as: PK, unique key

Last updated August 8, 2026

Definition

A primary key is a column or set of columns that uniquely identifies each row in a database table and cannot contain duplicates or (usually) nulls.

Real-World Example

In a users table, an auto-incrementing user_id primary key distinguishes two people who share the same name.

References

discuss://translation · public

Translation discussion

Anyone can read and write here. Pick a display name — no email or account. Please keep the thread constructive. Thumb up a rendering you agree with — that helps the editor see consensus; it does not publish the term by itself. You can edit or delete your own comments from this browser; another device or cleared site data cannot.

Community lists who wrote, on which term, and when.

Loading discussion…