Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207522 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 / tom
There is two difference between them.
1. The not null constraint is by default added to primary
key, it means, primary key attribute cannot accept null
values, whereas, the attribute declared as unique can accept
null values. It is the major difference between the two.
2. Secondly, we can have only one primary key in a relation,
whereas, multiple attributes can be declared unique at the
same time.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / jason james john
unique key is a key that uniquely defines the characteristics of each row whereas primary key consists of characteristics that cannot collectively be duplicated by any other row.primary key will not allow null values whereas unique key will allow nulls.
| Is This Answer Correct ? | 1 Yes | 0 No |
primary key does not null,but unique key also null.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / rajkumar tiwari
Primary key contain non repetitive value and not null
value,and primary key is created on clustered index.In the
table their should be one primary key column.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / himanshu porwal
Primary key does not allow null values whereas in UNIQUE constraint we can have 1 null value means for that column one null value is allowed.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / praveen
primary key not allows null values, but unique key allows null values. only one primary is possible in one table, but multiple unique keys are possible in a table. Each unique key accepts only one null field. Both are used to prevent repeated entry of values.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / suman chatterjee.
uniqe key may contain null values but primary key can not take the null values.
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / mareeswaran-jeyakani
The primary key cannot be accept the null values.The unique key can accept null values. assume that you have a two
columns column1 having primary key constraint and column2 having unique constraint if u try to insert null into column2 it will accept that values whereas column1 will not accept the null values.
THANK YOU.ALL THE BEST...............
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / yogesh kumar
primary key is unique define in a table, it means if u
declare primary key value is not allows duplicate and null.
unique key allows repeats' a value and null.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a table in oracle?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
how to store only time in a data base table
How to call a sub procedure?
I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
What are the limitations of check constraint?
What happens in oracle commit?
What is oracle rowcount?
Please explain the difference between outer join and inner join? With examples would be appreciable..!
How to define a sub function?
How to convert characters to times in oracle?
Describe the different type of Integrity Constraints supported by ORACLE ?
Oracle General 
