Primary keys Used for data retrieval, updates, and deletions. They're also used to enforce referential integrity. Unique keys Used to remove duplicate values. They can also be used when a primary key is absent.