What's the difference between a primary key and a unique key?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / srinivas

10 Answers
15504 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What's the difference between a primary key and a unique key?..

Answer / raj

In primary key not allowed any null value while in unique
key one null value allowed.

Is This Answer Correct ?

22 Yes

1 No

What's the difference between a primary key and a unique key?..

Answer / srinivas

Primary key is a combination of unique+not null+cluster
index and it will not allow any duplicate values, null
values, and it's data will be arranged in ascending order
due to clustered index. Only one primary key is allowed
per table.

Unique key is a key which will not accept any duplicate
values, but it will accept one null value. We can place
any number of unique keys per table.

Is This Answer Correct ?

17 Yes

0 No

What's the difference between a primary key and a unique key?..

Answer / awdhesh

By default Primary Key Create Cluster index while unique
ker create non cluster index

Is This Answer Correct ?

17 Yes

1 No

What's the difference between a primary key and a unique key?..

Answer / sachin patil

only 1 p.K. have per table

u can have multipale Unique key per table

Is This Answer Correct ?

15 Yes

4 No

What's the difference between a primary key and a unique key?..

Answer / karthick

PRIMARY KEY AND UNIQUE KEY

* Both Enforces Uniqueness
* Primary key Creates clustered index
unique key creates non clustered index
* primay key does not allows null value
unique key allows 1 null value

Is This Answer Correct ?

10 Yes

0 No

What's the difference between a primary key and a unique key?..

Answer / karthikumar

The difference is primary key does not allow any one null
value,but unique allow only one null value,because it
consider null as one value

Is This Answer Correct ?

8 Yes

1 No

What's the difference between a primary key and a unique key?..

Answer / mrityunjay kumar

There are difference between Primary key and unique key.

1. Primary key allow not null value where as unique key
allow only one null value.

2. Primary key Creates clustered index where as unique key
creates non clustered index.

3. Primary key is only one in a table where as unique key
is multiple in a table.

4. Primary key is not accept duplicate value where as
Unique key is also not accept any duplicate values, but it
will accept one null value.

Is This Answer Correct ?

8 Yes

1 No

What's the difference between a primary key and a unique key?..

Answer / sunil

HI ALL

IN CASE OF INSERTING REPETED NULL IN UNIQUE KEY COLOUMN ,
IF IT IS COMPOSITE KEY IS POSSIBLE. . . ANY LOGICAL RESON?

Eg:
CREATE TABLE TRY(ROLL NUMBER,LIB_CARD_NO NUMBER,
CONSTRAINT CON_UNQ UNIQUE(ROLL,LIB_CARD_NO));

INSERT INTO TRY VALUES(NULL,NULL);
--> 1 ROW CREATED
INSERT INTO TRY VALUES(NULL,NULL);
--> 1 ROW CREATED -- REPETED NULL ARE ALLOWED!!!!

Is This Answer Correct ?

2 Yes

0 No

What's the difference between a primary key and a unique key?..

Answer / amit

-Both are Unique means they do not accept duplicate value.

-Primary key by default Clustered Index where as Unique Key
is a Non-Clustered Index.

-Primary Key does not accept null value where as Unique Key
accept only one Null Value.

-A table can have only one Primary Key where as A table can
have multiple Unique Key.

Is This Answer Correct ?

2 Yes

0 No

What's the difference between a primary key and a unique key?..

Answer / hameed

Primary key does not allow any null value in a table where
as Unique key allows only one null value

Primary key is by default a Clustered Index where as Unique
key is a non-clustered index

Is This Answer Correct ?

2 Yes

0 No

Post New Answer