what is difference between "Primary key" and "Unique key"?
- 4 Answers
- 8416 Views
- PreVator, I also Faced
- E-Mail Answers
Answer Posted / nitin gupta
Uniques: Enforce unique data in the database
it allows row containing null value but only once
It implements non clustered index.
primary key: Enforce unique data in the database
it don't allow any record containing null value
it implements clustered index (data physically
sorted)
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are different clauses used in sql?
What is your daily office routine?
what are string data types? : Sql dba
Can there be 2 primary keys in a table?
What is the requirement of self-join?
Explain 3 basic parts of a trigger.
How can get second highest salary in sql?
How do I count records in sql?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What is oracle sql called?
How do you take the union of two tables in sql?
What is the difference between the sql*loader and import utilities? : aql loader
What is mdf ldf and ndf?
what are the differences between char and varchar? : Sql dba
Can triggers stop a dml statement from executing on a table?
