Interested to Buy Any Domain ? << Click Here >> for more details...
What is differance unique key and primary key.
- 7 Answers
- 11618 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
Is the primary key an index?
What is nosql db?
Is sql easier than java?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
Why is theta join required?
How to run sql statements with oracle sql developer?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
Is sql low level language?
what is a field in a database ? : Sql dba
What is the difference between instead of trigger and after trigger?
Can we commit inside a trigger?
How do I audit the sql sent to the server?
How many parts of a pl sql block are optional?
How can we find duplicate records in a table?
Are stored procedures faster than dynamic sql?
