Question: what is the difference between primary and secondary key in dbms?
Answer: 3 Answers. Primary Key: Is a single field chosen by the designer to uniquely identify a record in a table (relation), cannot be null (empty/unassigned). ... Secondary (or Alternative) Key: Is any field in the table that isn't selected to be any of the two types above.