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
how can you check the level of fragmentation on a table? : Sql server administration
What is the data tier application?
What is a db view?
What is a result set object returned by mssql_query()?
How to resolve the orphan use problem? : sql server security
What are different types of database indexes?
How to create user defined functions with parameters?
How to receive returning result from a query?
what is dbcc? : Sql server database administration
How to stop log file growing too big?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
How do you delete a trigger?
Explain user defined functions?
How do you create an execution plan?