What's the difference between a primary key and a unique key?
- 10 Answers
- 16015 Views
- Wipro, I also Faced
- E-Mail Answers
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 the difference in login security modes between v6.5 and 7.0? : Sql server database administration
What is logshipping and its purpose?
Why use stored procedures in sql server?
What are page splits?
Can we insert data into view sql server?
What are sql servers used for?
What is the difference between writing data to mirrored drives versus raid5 drives
What is a result set object returned by mssql_query()?
How to replace null values in expressions using isnull()?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
What does it mean to normalize data?
Explain security with sql azure?
Explain the database you used in your final year project?
How you can move data or databases between servers and databases in sql server?
Explain what is the use of custom fields in report?
