Re: Difference between Unique Index and Primary Key?

2002-04-06 Thread Paul DuBois
the answers are no, and yes. Brent At 05:09 PM 4/5/2002, you wrote: Here are a few easy philosophical questions for a change: 1) For performance or storage benefits, is there a difference between a Unique Index and Primary Key? There can be only one primary key. There can be multiple unique

Difference between Unique Index and Primary Key?

2002-04-05 Thread BD
Here are a few easy philosophical questions for a change: 1) For performance or storage benefits, is there a difference between a Unique Index and Primary Key? 2) Is there a reason why I should use Primary Key instead of a Unique Index? 3) Why isn't there a syntax for create primary index

Re: Difference between Unique Index and Primary Key?

2002-04-05 Thread Paul DuBois
Here are a few easy philosophical questions for a change: 1) For performance or storage benefits, is there a difference between a Unique Index and Primary Key? There can be only one primary key. There can be multiple unique indexes. Primary keys cannot contain NULL values. Unique indexes can

Re: Difference between Unique Index and Primary Key?

2002-04-05 Thread BD
) For performance or storage benefits, is there a difference between a Unique Index and Primary Key? There can be only one primary key. There can be multiple unique indexes. Primary keys cannot contain NULL values. Unique indexes can allow NULL values (and in fact, NULL is the one value that can