A column or group of columns known as a unique key serves as a unique identifier for each record in a table. Every value in this Key must be distinct. A primary key cannot have any null values, but a unique key can have one, which is how it differentiates from a primary key.