Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between a primary key and a unique key?
- 10 Answers
- 18363 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / mrityunjay kumar
There are difference between Primary key and unique key.
1. Primary key allow not null value where as unique key
allow only one null value.
2. Primary key Creates clustered index where as unique key
creates non clustered index.
3. Primary key is only one in a table where as unique key
is multiple in a table.
4. Primary key is not accept duplicate value where as
Unique key is also not accept any duplicate values, but it
will accept one null value.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How to create user messages with print statements in ms sql server?
Are null values the same as that of zero or a blank space?
What are rest-style architecture's?
What is the report model project?
what is denormalization? : Sql server database administration
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What are the types of lock supported by ?
Explain differences between web edition and business edition?
what is hash nonclustered index
What does indexation mean?
Explain following error properties?
Explain log shipping and mention its advantages.
How to call a function from a stored procedure in SQL Server ?
How to Sync Two SQL Azure Databases?
How many columns can we include on clustered index ?
