Re: diff. between Primary-Key and unique index

From: <bob_jenkins_at_my-deja.com>
Date: Tue, 25 Jan 2000 01:31:47 GMT
Message-ID: <86iue3$djg$1@nnrp1.deja.com>

In article <ErWh4.81$7R.1018_at_news.colt.net>, "Bob Bain" <bob.bain_at_terra-nova.e-mail.com> wrote:
> Where is it documented that unique indexes shouldn't
> be used anymore, or is this just an Urban Legend that's
> floating around??

The documentation discouraged explicit unique indexes from 7.0 up to 8.0, but as of 8.1 they're encouraged again. They should have been encouraged all along. Depending on unique indexes to be created as a side effect of creating constraint is unreliable because the side effects of creating constraints can change from version to version.

Foreign keys can reference unique and primary keys, but they can't reference unique indexes.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jan 24 2000 - 19:31:47 CST