Interested to Buy Any Domain ? << Click Here >> for more details...
can you any body tell me the difference between candidate
key and primary key
- 4 Answers
- 8271 Views
- I also Faced
- E-Mail Answers
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
How do I find sql server instance name?
What is meant by dirty read?
How to get the definition of a user defined function back?
Explain security with sql azure?
What is difference between joins and subqueries?
 Explain what is sql override for a source taLle in a mapping?
Where the sql logs gets stored? : sql server database administration
What are the differences between stored procedure and the dynamic sql?
What is thr feature of change data capture?
What are the types of dml?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What is difference between delete and truncate commands?
What are the properties of the transactions?
What is bit data type? What's the information that can be stored inside a bit column?
Does union all remove duplicates?
