can you any body tell me the difference between candidate
key and primary key
Answer Posted / 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 |
Post New Answer View All Answers
What is table constraint?
What is etl - extraction, transformation, and loading?
How to read data in a table with "select" statements?
How to get nth highest salary from employee table.
How to connect Azure federated root database and apply federation in entity framework?
Can select statements be used on views in ms sql server?
Difference between connected and disconnected database in .net with sql server?
How to skip remaining statements in a loop block using continue statements?
How to list all triggers in the database with sys.triggers in ms sql server?
Explain unique key in sql server?
Explain different backup plans?
What is executereader?
What is order of B+tree?
How do I find the query plan in sql server?
What is b tree index?