What is the difference between a primary key and a unique constraint?
primary-key, sql
Solution
A primary key is a unique field on a table but it is special in the sense that the table considers that row as its key. This means that other tables can use this field to create foreign key relationships to themselves.
A unique constraint simply means that a particular field must be unique.
Problem
What is the difference between a primary key and a unique constraint?