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


Please Help Members By Posting Answers For Below Questions

How to delete a database in ms sql server?

643


How to find the version of sql server? : sql server database administration

710


How much is a sql server license?

602


Explain what are the authentication modes in sql server?

583


What are the different types of indexes?

685






What is constraints and its types?

574


What are joins in sql and what are the different types of joins?

628


what is sql server? : Sql server database administration

605


Why do we use stored procedures in sql server?

589


How to populate a table in sql server?

592


why would you use sql agent? : Sql server database administration

624


What is the difference between row_number and dense_rank?

511


What do you mean by an execution plan? Why is it used?

626


How to make a column nullable?

680


Does sql server 2016 have ssms?

620