unique key in ms sql server
/* To create the Unique Key.
Unique Key constraint to enforce uniqueneess of a column i.e. the column
shouldn't allow duplicate values.*/
ALTER TABLE Table_Name
ADD CONSTRAINT Constraint_Name UNIQUE (Column_Name)unique key in ms sql server
/* To create the Unique Key.
Unique Key constraint to enforce uniqueneess of a column i.e. the column
shouldn't allow duplicate values.*/
ALTER TABLE Table_Name
ADD CONSTRAINT Constraint_Name UNIQUE (Column_Name)primary key and unique key in sql
What is the difference between UNIQUE and PRIMARY KEY constraints?
There should be only one PRIMARY KEY
in a table whereas there can be
any number of UNIQUE Keys.
PRIMARY KEY doesn’t allow NULL
values whereas Unique key allows NULL values.Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
