Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between a primary key and a unique key?
- 10 Answers
- 18630 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / karthick
PRIMARY KEY AND UNIQUE KEY
* Both Enforces Uniqueness
* Primary key Creates clustered index
unique key creates non clustered index
* primay key does not allows null value
unique key allows 1 null value
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
How to replace null values in expressions using isnull()?
What is attribute? : sql server analysis services, ssas
Can sub report data source be different from that of the parent report?
What it means to be triggered?
How to stop log file growing too big?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
What is the difference between seek predicate and predicate?
Explain syntax for viewing trigger?
When is update_statistics command used?
What are the lambda triggers?
How to find out what is the default collation in a database?
What is scalar user-defined function?
What is default constraint?
Can you insert NULL in unique column?
What is transaction server isolation?
