can you any body tell me the difference between candidate
key and primary key
Answer Posted / 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 |
Post New Answer View All Answers
What is encryption key?
what is a deadlock? : Sql server database administration
How to drop an existing user defined function in ms sql server?
How to delete existing triggers using "drop trigger"?
Explain where clause?
Which command is used for user defined error messages?
What is the need for group functions in sql?
Is the log file is a part of file group?
What are the differences between ms sql server & oracle?
How to select all columns of all rows from a table with a select statement in ms sql server?
What is the advantage of sql server?
How to restore performance issues and how to check?
Can two different columns be merged into single column? Show practically?
Can you insert NULL in unique column?
What is use of attributehierarchyenabled? : sql server analysis services, ssas