Interested to Buy Any Domain ? << Click Here >> for more details...
What is differance unique key and primary key.
- 7 Answers
- 11875 Views
- EDS, I also Faced
- E-Mail Answers
Answer Posted / madhu
unique key:
1.unique key will accept more than one null value.
2.whenever u created a unique key, then internally one non-clustered index will be created(one table can have more than one Non-clustered index).
3.one table can have more than one unique key.
Primary key:
1.One table should have one primary key only.
2.primary key will not accept null values.
3.whenever u created a primary key then internally one clustered index will be created(one table can have only one clustered index).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you modify a table in sql?
How do I run a pl sql program?
What is a mutating table and a constraining table?
what are the limitations of identity column? : Transact sql
What do you understand by pl/sql cursors?
What does sign mean sql?
What are the usages of sql?
What is group by in sql?
What is rollback?
Can we call dml statement in function?
what are rollup and cube in t-sql? : Transact sql
How do you know if a relationship is 2nf?
What is normalisation and its types?
Which normal form is best?
What port does sql server use?
