Topmusicanswers
You can only have one primary key, but you can have multiple columns in your primary key. You can also have Unique Indexes on your table, which will work a bit like a primary key in that they will enforce unique values, and will speed up querying of those values.
Can you have multiple primary keys?
You ask if you can have more than one primary key field and you most certainly can. You can have only one primary key, but that can consist of as many columns as you need to uniquely identify your rows.
Can we have 2 primary keys in a table?
It is possible for a table to have multiple candidate keys , which effectively behave similar to a primary key in that a candidate key is unique, NOT NULL , and is a singular representation of that table record.
