Differences between a primary key and a unique key

What are the differences between a primary key and a unique key?

E

Expert

Verified

Both primary and unique keys are defined to make sure unique row.

• Primary key makes a clustered index upon the column by default.

• Unique makes a non-clustered index by default.

• Primary key does not permit NULLs, but unique key permits one NULL only.

   Related Questions in PL-SQL Programming

©TutorsGlobe All rights reserved 2022-2023.