What's the difference between a primary key and a unique key?
Answer Posted / srinivas
Primary key is a combination of unique+not null+cluster
index and it will not allow any duplicate values, null
values, and it's data will be arranged in ascending order
due to clustered index. Only one primary key is allowed
per table.
Unique key is a key which will not accept any duplicate
values, but it will accept one null value. We can place
any number of unique keys per table.
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
How to execute a stored procedure in ms sql server?
What the different types of Replication and why are they used?
Can we use pragma autonomous_transaction in trigger?
What is the use of keyword with encryption.
How to Check if table exists in sql server?
What is self join in sql server joins?
How to remove duplicate rows from table except one?
What is the difference between varchar and nvarchar?
What does select 1 mean?
Can you edit the .rdl code associated with a linked report?
How to create an identity column?
What is normalization 1nf 2nf 3nf?
What is unpivot?
What is the difference between NOROW and LOCKROW?