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 set database to be single_user in ms sql server?
How to return the second 5 rows in ms sql server?
Explain subquery and state its properties?
Define tool Manage Statistics in SQL Server 2000 query ?
Can you type more than one query in the query editor screen at the same time?
What is isolation levels?
Can you index views?
Which Model uses the SET concept
What are the different ways you can create databases in sql server?
How to write an inner join with the where clause in ms sql server?
How to test odbc dsn connection settings?
What is an example of a primary key?
What is filter index?
What stored by the model?
Explain the properties of subqueries in sql server?