Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between "Primary key" and "Unique key"?
- 4 Answers
- 9260 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
How to get list of all tables from a database?
What is query syntax?
What is join view in sql?
how many ways we can we find the current date using mysql? : Sql dba
What is dialect in sql?
Does truncate free space?
What is varchar sql?
What is difference between sql and excel?
what are the advantages of mysql in comparison to oracle? : Sql dba
What is a ddl command?
Why do we use procedures?
what are string data types? : Sql dba
Can cursors be part of a trigger body?
What is sql clause?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
