Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210672 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
Answer Posted / 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 |
Post New Answer View All Answers
How to delete all rows a table in oracle?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What is materialized view in Oracle?
How to sort output in descending order in oracle?
what are actual and formal parameters?
What is the data type of dual table?
How to create lov dynamically at runtime & attach to text field?
How to use "in" parameter properly?
How do I spool to a csv formatted file using sqlplus?
Explain enable novalidate constraint.
Is there any function in oracle similar like group_concat of mysql?
How to get last row id?
What are the limitations oracle database 10g xe?
What is set verify off in oracle?
What do you understand by a database object?
