Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between a primary key and a unique key?
- 10 Answers
- 18629 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / srinivas
Primary key is a combination of unique+not null+cluster
index and it will not allow any duplicate values, null
values, and it's data will be arranged in ascending order
due to clustered index. Only one primary key is allowed
per table.
Unique key is a key which will not accept any duplicate
values, but it will accept one null value. We can place
any number of unique keys per table.
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
What is hot add cpu in sql server 2008?
What is named query? : sql server analysis services, ssas
What options are available to audit login activity? : sql server security
Mention the different types of replication in sql server.
What is replication with database mirroring? : sql server database administration
What is the benefit of normalization?
What are the benefits of normalization?
In which format does an image save in SQL Server database ?
What the difference between UNION and UNIONALL?
What do you mean by the term 'normalization'?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What are the events recorded in a transaction log?
how would you troubleshoot blocking? : Sql server database administration
What should be the fill factor for indexes created on tables? : sql server database administration
what's the maximum size of a row? : Sql server database administration
