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
Is the primary key column of a table an index in ms sql server?
explain different levels of normalization? : Sql server database administration
What are the limitations in ssrs on sql server express edition?
What do you mean by data manipulation language?
What does normalization do to data?
What happens if you add a new index to large table?
What is the difference between having clause and where clause in sql server?
What are the different types of backups avaialabe in sql server 2005?
What is a file group?
what are user defined datatypes and when you should go for them? : Sql server database administration
How to create a view on an existing table in ms sql server?
Explain Normalization and DE normalization
Will count(column) include columns with null values in its count?
What is difference between line feed ( ) and carriage return ( )?
What are the types of stored procedures in an sql server?