Unique Constraint

Overview

A UNIQUE constraint ensures that all values in a column or set of columns are distinct across all table rows.

Code Examples

SQL

CREATE TABLE users (
    user_id INT PRIMARY KEY,
    email VARCHAR(255) UNIQUE
);

Summary

The UNIQUE constraint prevents duplicate column values while allowing NULL values depending on the RDBMS.