Re: Test if Data for a Field is UNIQUE

From: Walt <walt_askier_at_SHOESyahoo.com>
Date: Tue, 24 Jan 2006 10:30:05 -0500
Message-ID: <1KrBf.3007$yb2.834@news.itd.umich.edu>

Mladen Gogala wrote:
> On Mon, 23 Jan 2006 16:57:36 -0500, Walt wrote:
>

>>Well, yes and no.  In theory it is possible to have a unique constraint 
>>without an index.

>
> Walt, it is possible to create a non-unique index and then create a
> unique or PK constraint with "enable novalidate" option. It will work.
> Existing duplicate data will be tolerated, but you will not be able to
> enter new duplicate rows.

Thanks. I see what you're getting at now.

//Walt Received on Tue Jan 24 2006 - 09:30:05 CST