Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between a primary key and a unique key?
- 10 Answers
- 17957 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
Can sql servers link to other servers like oracle?
Explain external key management in sql server 2008
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
What is a raid and what are different types of raid configurations?
What are cursors stored procedures and triggers?
When cursors are useful?
What is the return type of executeupdate ()?
What triggers long term care?
What is sql profiler. What are the default templates with it? : sql server database administration
Why should you use or avoid select * statements?
How to add a new dsn with the odbc driver for sql server?
List the different normalization forms?
Do you know the capabilities of cursors?
What is user defined stored procedures?
Define clusters?
