List:General Discussion« Previous MessageNext Message »
From:Vivek Khera Date:November 4 1999 7:00pm
Subject:Re: Alter table with UNIQUE INDEX
View as plain text  
>>>>> "JT" == Jeff Thies <cyberjeff@stripped> writes:

JT>   I've got a table with duplicate entries, I'd like to alter the table
JT> so that I have a unique index (and then use REPLACE INTO).

JT>   What happens to my rows that have the same value that are now in a
JT> unique index???

When you alter your table to have the unique index, it will complain
and then refuse to generate said index.  That is, you need to
alter/delete those rows before the index will be created.  That said,
running the alter table command to add the index helps find those
rows.

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@stripped       Rockville, MD       +1-301-545-6996
PGP & MIME spoken here            http://www.kciLink.com/home/khera/
Thread
Alter table with UNIQUE INDEXJeff Thies4 Nov
  • Re: Alter table with UNIQUE INDEXVivek Khera4 Nov
  • Re: Alter table with UNIQUE INDEXGerald Clark5 Nov