Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210592 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 |
How to commit the current transaction in oracle?
Differentiate between function and procedure in oracle.
What are the varoius components of physical database structure of oracle database?
What are the limitations oracle database 10g xe?
Can we write insert statement in function in oracle?
What is difference between sid and service name in oracle?
What is the difference between normal and corelated subqueries?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What are the factors causing the reparsing of SQL statements in SGA?
What is catalog in Oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to do paging with oracle?
Oracle General 
