What's the difference between a primary key and a unique key?
- 10 Answers
- 16016 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / hameed
Primary key does not allow any null value in a table where
as Unique key allows only one null value
Primary key is by default a Clustered Index where as Unique
key is a non-clustered index
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are indexes in ms sql server?
How to create a dynamic cursor with the dynamic option?
How to create a view on an existing table in ms sql server?
Explain differentiate between a having clause and a where clause?
How to replace given values with null using nullif()?
How secure is sql server database?
What is the command used to check locks in microsoft sql server?
What are the types of joins in sql?
What is the usage of sign function?
What do we need queues in sql service broker?
What are key constraints?
What to check if a User database is locked?
Do you know how to implement service broker?
How do I know if localdb is running?
In which format does an image save in SQL Server database ?
