What are the differences between a Primary key and a Unique constraint? -------------------------------------------------------------------------- * On the superficial level: 1. One table can only have 1 PK. It can have many UKs. 2. UKs can not be used for referencing by columns in other tables. * The more meaning differences: 1. PKs do not allow NULL, UKs allow NULL.