| Author: UltimateRengan 29 Aug 2008 | Member Level: Diamond | Rating:  Points: 5 |
hi,
candidate Key [Primary Key] is a key which maintains the Row Unique.
it Can be defined based on the entity.
composite Key can be either Primay or Unique Key.
More then One Key columns are said to be composite keys.
Candidate Key(Primary Key) is a column in a table which has the
ability to become a primary key.But a primary key does not necessarily have to be the target of any foreign keys.
The candidate key must be unique within its domain.
i hope this may help u
|
| Author: http://venkattechnicalblog.blogspot.com/ 31 Aug 2008 | Member Level: Diamond | Rating: Points: 2 |
Part of the primary key is referred to as candidate key.
Regards,
Venkatesan Prabu .J
http://venkattechnicalblog.blogspot.com/
|