primary key 1

[hoofit]

I have a table where not using a primary key would help. If I set the field indexed yes w/ no dupes, does this prevent duplicates adequately?
Thank you

hoofit

 

[traingamer]

I have a table where not using a primary key would help.

How would it help?

If I set the field indexed yes w/ no dupes, does this prevent duplicates adequately?

It should.

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[alvechurchdata]

The only difference you'll see is that a regular no-duplicates index will allow null values in the field and will allow any number of records to have null values. A primary key forbids nulls.

But I'm with Greg - how does it help if you don't have a primary key?

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[hoofit]

I see. I cannot allow any number of records to have nulls so I will need to use a primary key.

Thank you