what is primary and foreign key? Primary Key: A unique identifier for each row in a table. It ensures that no two rows have the same value in the primary key column(s), and it cannot contain NULL values. Foreign Key: A column or set of columns in one table that references the primary key in another table.