Articles → SQL SERVER → Unique Index In SQL Server
Unique Index In SQL Server
Purpose Of Unique Index
- Only unique values are allowed
- NULL value could be inserted.
Syntax
CREATE UNIQUE INDEX index_name ON table_name (column_name)
Example
Click to Enlarge
CREATE UNIQUE INDEX idx_unique_SampleTable_Test ON SampleTable (Test)
insert into SampleTable
values
(null) insert into SampleTable
values
('value1') insert into SampleTable
values
('value2') insert into SampleTable
values
('value1')