Difference between primary key and unique key ?
- 77 Answers
- 190506 Views
- Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anuradha
The unique column constraints permits multiple entries of
null in the column. these null values are clubbed at top of
column in order they were entered into table. this is
essential difference .
Table have more than 1 unique key which is not possible in
primary key
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / chauhan rakesh botad
Primary key doesnot allow null value but unique key allows
null value. We can declare only one primary key in a table
but a table can have multiple unique key(column assign).
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pawan mishra
One table may have more than one Unique Key Constraint
columns, but should have only one Primary Key Constraint
column.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ibrahim
PRIMARY KEY is identity of each row. UNIQUE KEY also
identity of each row.
PRIMARY KEY not accepts null values but unique can accept null.
but the core different between primary key and unique is we use primary key to link tow tables with each other but we can not use unique key to do this.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pandiyan
Primary key doesnot allow null value but unique key allows
null value.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / chetan sharma
Primary key creates Clustered Index.
Unique key creates non-clustered Index.
the no of primary key in a table is one but the no of
unique is more then one
there is only one primary key for one table;
it can not acept null values;
any no uniquefor a table;
it can accept null values;
which the rows are unique value;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / lucky
Primary key not accepts to null values in database, but
uniqe key accepts to the null values in database.
Each table having only one PRIMARY KEY.And my contain many
UNIQUE KEYS.
PRIMARY KEY is identity of each row. UNIQUE KEY also
identity of each row.
BOTH keys will not contain repeated value.
BUT UNIQUE KEY will contain NULL value but PRIMAY key will
not contain NULL value.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pramod paunikar
Both primary key and unique enforce uniqueness of the
column on which they are defined. But by default primary
key creates a clustered index on the column, where are
unique creates a non-clustered index by default. Another
major difference is that, primary key does not allow NULLs,
but unique key allows only one NULL only.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / manoj routh
Both primary key and unique enforce uniqueness of the column
on which they are defined. But by default primary key
creates a clustered index on the column, where are unique
creates a nonclustered index by default. Another major
difference is that, primary key doesn't allow NULLs, but
unique key allows one NULL only.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sikander
Primary key does not allow null value but unique key allows
null value. suppose tableA two column : columnB & columnC .
where coulmnB is primary key & columnC is unique key.
If we insert null value in columnB.It will not accept
columnB but columnC
| Is This Answer Correct ? | 1 Yes | 0 No |
Explain the difference between a procedure and a function?
20. Using a set operator, display the client number of all clients who have never placed an order.
Explain oracle instance.
What is SAVE POINT ?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What are the uses of Database Trigger ?
What is save point in oracle database?
what is the use of system.effective.date variable in oracle?
How to do a full database export?
What is coalesce function?
How to rollback the current transaction in oracle?
What is pragma autonomous transaction in oracle?
Oracle General 
