SQL Server

SQL Server UNIQUE constraint



 Like (0)  Dislike (0)

SQL Server UNIQUE constraints allow you to ensure that the data stored in a column, or a group of columns, is unique among the rows in a table

CREATE TABLE user(
id INT IDENTITY PRIMARY KEY,
name VARCHAR(255) NOT NULL,
email VARCHAR(255),
UNIQUE(email)
);

If you enter a duplicate email id in the database, the error will show.
Violation of UNIQUE KEY constraint 'UQ__user__AB23436417240E4E'. Cannot insert duplicate key in object 'user'. The duplicate key value is (test@gmail.com)

0 Comment's

Comment Form

Submit Comment
If opportunity doesn’t knock, build a door.⛩

Popular Post

WPF

How to Use Logger in WPF Application

C-Sharp

Update Specific Users Out of Oce Settings C# with Example

C-Sharp

Retrieve Specified User''s Out of O ce Settings C# with Example

C-Sharp

Large Object Heap compaction C# with Example

C-Sharp

Weak References C# with Example

C-Sharp

Source code in the view C# with Example