Then what is the difference in these two statements?
alter table Table1
add constraint Table1_UC1
unique (Field1, Field2)
and
create unique index Table1_Field1Field2
on Table1 (Field1, Field2)
Thanks,
Thomas LeBlanc
>From: Dennis Gearon <gearond@fireserve.net>
>To: Thomas LeBlanc <thomasatiem@hotmail.com>
>Subject: Re: [GENERAL] Unique Index vs. Unique Constraint
>Date: Fri, 10 Oct 2003 15:16:12 -0700
>
>Uniquely so!
>
>Thomas LeBlanc wrote:
>
>>Does a Unique Constraint build a unique index?
>>
>>What is the difference?
>>
>>Thanks,
>>Thomas LeBlanc
>>
>>_________________________________________________________________
>>Get a FREE computer virus scan online from McAfee.
>>http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 6: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>>
>
_________________________________________________________________
Help protect your PC. Get a FREE computer virus scan online from McAfee.
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963