Re: Primary Keys vs. Unique Index
From: Tonyg246 <tonyg246_at_aol.com>
Date: 2 Jan 1995 21:38:17 -0500
Message-ID: <3eadap$n8k_at_newsbf02.news.aol.com>
Date: 2 Jan 1995 21:38:17 -0500
Message-ID: <3eadap$n8k_at_newsbf02.news.aol.com>
In my opinion, I use the constraints whenever possible due to the ease of disabling/re-enabling.
However, it should be kept in mind that a UNIQUE index is not the same as
a primary key constraint, as implied in the original note. A primary key
uses a unique index for enforcement with an additional check for null
values. On the otherhand, a unique index created via a 'create unique
index' statement will
allow null values.
Tony Garciaserra Received on Tue Jan 03 1995 - 03:38:17 CET