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
Can two tables share the same primary key?
Explain iaas, paas and saas?
What is multilevel indexing?
How many full-text indexes can a table have?
Can you leave a union at any time?
What is a trigger? Why we need it?
How many types of built in functions are there in sql server 2012?
Define self join?
How to define the name and server for a new dsn?
What is user defined stored procedures?
How can we solve concurrency problems?
What is the purpose of data source?
What is the difference between varchar and varchar(max) datatypes?
What are exact numeric data types in ms sql server?
What are the essential components of sql server service broker?