Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between a primary key and a unique key?
- 10 Answers
- 18372 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 do I shrink an ldf file?
What are ddl triggers and types of ddl trigger?
What is query processing?
Is it safe to delete log files?
Explain filestream storage of sql server 2008?
How do triggers work?
Do you have any idea about the tcl commands?
What is clustered vs nonclustered index?
What number sorts of privileges are accessible in sql?
What is the difference between composite index and covering index?
How to use "begin ... End" statement structures in ms sql server?
How to find table changes in sql server?
How to create a view on an existing table in ms sql server?
Can sql servers link to other servers?
What is used to replicate sessions between instances in coldfusion clusters?
