LGSGEEK

 Profile Answers by LGSGEEK 

• Mar 29th, 2008

 

You can make one (or more) columns unique in a table by defining a UNIQUE NONCLUSTERED index on the column.

ashwani.kumar

 Profile Answers by ashwani.kumar 

• Sep 10th, 2008

 

No it is not possible bcz primery key does not allowed null value, but in unique key one null value allowed

cybersavvy

 Profile Answers by cybersavvy 

• Feb 19th, 2009

 

Yes, its possible to have PRIMARY KEY and UNIQUE keys in the same table on different columns.

UNIQUE key constraint allows the column to have distinct & one NULL values.

pavan

• Jul 27th, 2011

 

If a column allows the duplication once is known as a unique key.i.e; Unique Key allows duplication once.But, Primary Key will not allow duplication.

Code
CREATE TABLE Employee


(


 EmployeeID CHAR(5) NOT NULL CONSTRAINT


 pkID PRIMARY KEY,


 EmployeeName VARCHAR(30) NOT NULL,


 Title VARCHAR(30) NOT NULL,


 Department VARCHAR(30) NOT NULL,


 Phone CHAR(15) NOT NULL CONSTRAINT unqPhone UNIQUE


) 

erik

• Jul 21st, 2012

 

SQL UNIQUE key...

The UNIQUE constraint uniquely identifies each record in a database table.

The UNIQUE and PRIMARY KEY constraints both provide a guarantee for uniqueness for a column or set of columns.

A PRIMARY KEY constraint automatically has a UNIQUE constraint defined on it.

Note that you can have many UNIQUE constraints per table, but only one PRIMARY KEY constraint per table.

SQL UNIQUE Constraint on CREATE TABLE

The following SQL creates a UNIQUE constraint on the "P_Id" column when the "Persons" table is created:

SQL:

Code
CREATE TABLE Persons


(


P_Id int NOT NULL UNIQUE,


LastName varchar(255) NOT NULL,


FirstName varchar(255),


Address varchar(255),


City varchar(255)


)


 


ALTER:


 


ALTER TABLE Persons


ADD UNIQUE (P_Id)


 

SIMILARLY OTHERS

Code
SQL UNIQUE Constraint ON CREATE TABLE


 


The following SQL creates a UNIQUE constraint ON the "P_Id" COLUMN when the "Persons" TABLE IS created:


 


SQL:


 


CREATE TABLE Persons


(


P_Id int NOT NULL UNIQUE,


LastName varchar(255) NOT NULL,


FirstName varchar(255),


Address varchar(255),


City varchar(255)


)


 


ALTER:


 


ALTER TABLE Persons


ADD UNIQUE (P_Id)


 


SIMILARLY OTHERS


 


 

asifeqbal

 Profile Answers by asifeqbal 

• Mar 19th, 2015

 

UNIQUE key constraint enforce uniqueness of the column on which they are defined. It allows the column to have distinct & one NULL values. We can make one or more columns unique in a table by defining a UNIQUE NONCLUSTERED index on the column.
It is Possible to define Primary key and Unique key in the same table on different columns.

Code
<Column Name> <DATA TYPE> NOT NULL CONSTRAINT <Constraint Name> UNIQUE