What's the difference between a primary key and a unique key?
Answer Posted / amit
-Both are Unique means they do not accept duplicate value.
-Primary key by default Clustered Index where as Unique Key
is a Non-Clustered Index.
-Primary Key does not accept null value where as Unique Key
accept only one Null Value.
-A table can have only one Primary Key where as A table can
have multiple Unique Key.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is SQL Azure Fabric?
Does index speed up select statements?
What is pivot and unpivot?
What is report server project?
What is difference between unique and primary key?
What are the advantages of using a stored procedure?
What are the new security features added in sql server 2012? : sql server security
Explain the concepts and capabilities of sql server?
What is the maximum size of sql server database?
What is normalization of database?
what's the difference between a primary key and a unique key? : Sql server database administration
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
Give me any three differences between Truncate and Delete.
How to use “drop” keyword in sql server and give an example?
How do I trace a query in sql server?