Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between a primary key and a unique
key?
- 4 Answers
- 8730 Views
- I also Faced
- E-Mail Answers
Answer Posted / swapna
Both primary key and unique enforce uniqueness of the
column on which they are defined. But by default primary
key creates a clustered index on the column, where are
unique creates a nonclustered index by default. Another
major difference is that, primary key doesn't allow NULLs,
but unique key allows one NULL only.
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
How can we delete Duplicate row in table?
What are the differences between clustered and non-clustered index?
How do you delete a data source?
Which command is used for user defined error messages?
What is the usage of the sign function?
What are the basic features of a trigger in ms sql server?
How to return the date part only from a sql server datetime datatype?
What are the types of lock supported by ?
Is sql server difficult to learn?
Explain indexes disadvantages?
What are the character string functions supported by sql server 2005?
Explain database normalization?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
How connect excel to sql server?
