A primary key is a fundamental concept in relational databases — it uniquely identifies each record (row) in a table.
Key Characteristics of a Primary Key
- Uniqueness: No two rows can have the same primary key value.
- Non-nullable: Every row must have a value for the primary key; NULL is not allowed.
- Immutable (ideally): Primary key values should rarely change, as they anchor relationships across tables.
Nasdanika Models