What's the difference between a primary key and a unique key?
Answer Posted / karthikumar
The difference is primary key does not allow any one null
value,but unique allow only one null value,because it
consider null as one value
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Explain hostprotectionattribute in sql server 2005?
What is enhanced database mirroring in sql server 2008?
What is sql server transaction log file?
What are the five characteristics of good data?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
What are a scheduled jobs?
How to connect Azure federated root database and apply federation in entity framework?
What are the differences between decimal and float in ms sql server?
What is the difference between DataRow.Delete() and DataRow.Remove()?
What are the difference between primary keys and foreign keys?
How to search for a string in all stored procedure in sql server?
How to how to convert numeric expression data types using the convert() function??
How to get the definition of a stored procedure back?
Tell about MOM Tool(Microsoft Operator Manager)?