can you any body tell me the difference between candidate
key and primary key
Answer Posted / 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 |
Post New Answer View All Answers
What do you mean by table and field in sql?
How are the unique and primary key constraints different?
How to copy the tables, schema and views from one sql server to another?
What is difference between index and primary key?
What is the datatype of rowid?
What are the disadvantages of indexes?
Do you know clustered and non-clustered index?
How do you set a trace flag in sql server?
Comment,Datatypes are unlimited
What is the filtered index?
How to fetch the next row from a cursor with a "fetch" statement?
Why union all is faster than union?
What are the advantages of paper records?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
Difference between connected and disconnected database in .net with sql server?