A one-column UNIQUE rule checks one key cell.

highlighted = computed this step

One-column UNIQUE

A one-column UNIQUE rule checks one key cell per row.

one key cell\text{one key cell}

Read email keys

The rule uses 1 key column and finds 1 violation.

violations=1\text{violations}=1

UNIQUE constraint examples are tiny finite table checks; SQL dialect completeness, index implementation, locking, optimizer behavior, product behavior, and performance claims are out of scope.

One-column UNIQUE: base rowsidemailregionplan1adaeastbasic2beneastpro3adawestbasic4NULLeasttrial5NULLwesttrial6cyeastbasic UNIQUE rulenamecolumnsuq_email(email) UNIQUE keys by source rowsourceinputkeykeyStatus0(1, ada, east, basic)(ada)checkable1(2, ben, east, pro)(ben)checkable2(3, ada, west, basic)(ada)checkable3(4, NULL, east, trial)(NULL)NULL_component_does_not_collide4(5, NULL, west, trial)(NULL)NULL_component_does_not_collide5(6, cy, east, basic)(cy)checkable UNIQUE violationsleftrightkeyreason02(ada)duplicate_non_NULL_key Insert candidate checkfieldvaluepresentno UNIQUE factsfactvaluerowCount6constraintNameuq_emailkeyColumnCount1violationCount1tableValidnonullsCollideno_toy_SQL_like_conventioncandidateDecisionnone

Key rows are visible

The key table shows the extracted email key for every source row.

key per row\text{key per row}

Summary

One-column UNIQUE compares one displayed key at a time.

one-column rule\text{one-column rule}