Resolved: Primary Key is not obligatory in a table
When comparing PK vs Unique Key, in the number of keys (per table), PK should be 0, 1, instead of only 1, Right?
1 answers ( 1 marked as helpful)
Hi Jorge!
Thanks for reaching out.
A table in a database can have either 0 or 1 primary key (PK). This primary key can be a single column or a composite key consisting of multiple columns. However, regardless of being single or composite, there can only be one primary key per table.
Hope this helps.
Best,
Tsvetelin