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 |
Can we call stored procedure in view in sql server?
What is a collation?
explain different types of joins? : Sql server database administration
How do I find the port number for sql server?
What do you mean by sql server 2005 express management tools?
What is the data type of time?
How many tables can be joined in SQL Server?
How to disable a login name in ms sql server?
How to get the definition of a view out of the sql server?
Why truncate is ddl?
What are different types of statements that are supported by sql?
Can you link only other SQL Servers or any database servers such as Oracle?