can you any body tell me the difference between candidate
key and primary key
Answer Posted / arijit
A candidate key is a combination of attributes that can be
uniquely used to identify a database record without any
extraneous data. Each table may have one or more candidate
keys. One of these candidate keys is selected as the table
primary key.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to delete a database in ms sql server?
How to find the version of sql server? : sql server database administration
How much is a sql server license?
Explain what are the authentication modes in sql server?
What are the different types of indexes?
What is constraints and its types?
What are joins in sql and what are the different types of joins?
what is sql server? : Sql server database administration
Why do we use stored procedures in sql server?
How to populate a table in sql server?
why would you use sql agent? : Sql server database administration
What is the difference between row_number and dense_rank?
What do you mean by an execution plan? Why is it used?
How to make a column nullable?
Does sql server 2016 have ssms?