What's the difference between a primary key and a unique key?
Answer Posted / karthick
PRIMARY KEY AND UNIQUE KEY
* Both Enforces Uniqueness
* Primary key Creates clustered index
unique key creates non clustered index
* primay key does not allows null value
unique key allows 1 null value
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What do you understand by user-defined function in the sql server?
Why use triggers?
What is sql azure database?
Can a function call a stored procedure in sql server?
How many types of schemas are there?
What are drillthrough reports?
What are sub reports?
Mention the 3 ways to get a count of the number of records in a table.
How to use linked server?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is difference between unique and primary key?
What is the Control Flow in SSIS
Explain what are the different index configurations a table can have?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
Tell me the difference between clustered and non-clustered index?