Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210048 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 the difference between sql& oracle?
Anyone have the Latest Oracle Dumbs?While u have please forard to narain1411@gmail.com
what is cartesian product?
How can I see all tables in oracle?
How to store only time; not date and time?
How do I uninstall oracle 11g?
Can a Tablespace hold objects from different Schemes ?
how to genarate random numbers in oracle for particular row?
In what script is snap$ created? In what script is the scott/tiger schema created?
Why do you create or replace procedures rather that drop and recreate.
defination of bitmap index
what is difference between sql plus and sql*plus? (not sql and sql plus).
Oracle General 
