can you any body tell me the difference between candidate
key and primary key
- 4 Answers
- 6810 Views
- I also Faced
- E-Mail Answers
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
How do you size a resultset?
What does nvl stand for?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What is service broker? : sql server database administration
Can you always create a cache of a report?
What is self join in sql server joins?
what is isolation level at dead lock?
What is the return type of executeupdate ()?
How to test subquery results with the exists operator?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
What is ms sql server index?
How to fine-tune reports?
How to insert multiple rows with a subquery?
How to create an inline table-valued function?
What is openxml in sql server?
