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 are cursors? : Sql server database administration
How do I create a partition table in sql server?
What is a trigger in sql server?
How to create a new table in a given schema?
optimization techinques
Explain what is it unwise to create wide clustered index keys?
What is the use of MOVE keyword in restore command
Is null vs coalesce?
How to find 6th highest salary from Employee table ?
What is the difference between distinct clause and group by clause?
Explain what are magic tables in sql server?
What is page-level compression?