Middle
What are the limitations of a Primary Key?
sobes.tech AI
Answer from AI
Primary Key Constraints:
- Uniqueness: Values in the primary key column(s) must be unique for each row in the table.
- NULL not allowed: Columns declared as primary key cannot contain NULL values.
- One primary key per table: A table can have only one primary key, but it can consist of multiple columns (composite key).
- Stability of values: Primary key values should not change frequently, as this can affect data integrity and performance.
These constraints ensure the unique identification of each record in the table and maintain data integrity.