>Hi all
>Can anyone clear up the difference between primary and candidate indexes?
>
>Thanks.
In addition to what Hilmar told you:
You can only have one Primary key per table. Candidate means those keys are "candidates to be primary"
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer