can you any body tell me the difference between candidate
key and primary key
Answers were Sorted based on User's Feedback
Answer / vani
A candidate is a one that can identify each row in a table
uniquely.If a table has more than one candidate key , one
of them will become primary key.
The potential primary key is a candidate key.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
Answer / prasad
There can be more than one index in a table.
But only one field can be a Primary Key in a table.
All other index fields in a table are called candidate keys.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / pooja
A primary key is one that uniquely identiifes each row.
and there is only one primary key per table.
candidate key:All that fields which can be selected as
primary key are called candidate keys.
Is This Answer Correct ? | 0 Yes | 1 No |
What is the purpose of optimization?
Describe triggers features and limitations?
What is self contained scalar sub query?
What is the difference RDBMS and Graph Database?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
How to change the name of a database user?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
How to truncate the log in sql server 2012? : sql server database administration
How can you check the level of fragmentation on a table?
What do you understand by hotfixes and patches in sql server?
Simple example for difference between select and cursor in sql
What is the log shipping?