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 set database to be single_user in ms sql server?

561


How to return the second 5 rows in ms sql server?

630


Explain subquery and state its properties?

545


Define tool Manage Statistics in SQL Server 2000 query ?

524


Can you type more than one query in the query editor screen at the same time?

570






What is isolation levels?

564


Can you index views?

499


Which Model uses the SET concept

577


What are the different ways you can create databases in sql server?

567


How to write an inner join with the where clause in ms sql server?

550


How to test odbc dsn connection settings?

526


What is an example of a primary key?

505


What is filter index?

514


What stored by the model?

546


Explain the properties of subqueries in sql server?

540