Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210314 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 / dpkar
Primary Key:
Primary key will create column data uniqueness in the table.
Primary key will create clustered index by default
Only one Primay key can be created for a table
Multiple columns can be consolidated to form a single
primary key
It wont allow null values.
Unique Key :
Unique key constraint will provide you a constraint like
the column values should retain uniqueness.
It will allow null value in the column.
It will create non-clustered index by default
Any number of unique constraints can be added to a table.
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / priyranjan das
The basic differences between Primary Key and Unique key are as follows.
1) By default Primary Key will generate Clustured Index
whereas Unique Key will Generate Non-Clustured Index.
2) Primary Key is a combination of Unique and NOT NULL Constraints so it can’t
have duplicate values or any NUll
Whereas for Oracle UNIQUE Key can have any number of NULL whereas for SQL
Server It can have only one NULL
3) A table can have only one PK but It can have any number of UNIQUE Key.
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / kundn
Unique key Primary key
1. Can have null value 1. Can not have null value
2.Table can have multiple 2. Table Can have multiple unique
Unique keys keys
3Single column at a time 3. May be combination of one or
or more columns
| Is This Answer Correct ? | 14 Yes | 17 No |
Answer / ajoy
primary key and unique key both can be referenced to other
table as foreign key. please check this error message
ORA-02270: no matching unique or primary key for this
column-list
| Is This Answer Correct ? | 4 Yes | 7 No |
Answer / guna
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 ? | 9 Yes | 18 No |
Answer / vitthal parkar
Unique key Primary key
1. Can have null value 1. Can not have null value
2.Table can have multiple 2. Table Can have multiple unique
Unique keys keys
3Single column at a time 3. May be combination of one or
or more columns
| Is This Answer Correct ? | 35 Yes | 58 No |
How to test null values?
What is E-R diagram ?
2 Answers CGI, Keane India Ltd,
What is Water Mark in Oracle?
What is the data type of dual table?
State the various uses of dbcc command?
I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
How to insert a new row into a table in oracle?
how to insert data into partitioned table partition done by Range partition
What are oracle functions?
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
When can Hash Cluster used ?
What is the use of Redo Log Information ?
Oracle General 
