Re: Delete Duplicate Records !!!!

The most easy way is the following.

1. Export the table
2. Truncate the table
3. Define a (temporary) unique key on the column concerned
4. Import the table again. Duplicate values will be rejected 5.Drop the primary key.

Kind Regards

Edwin Kessels
ekessels_at_fnusa.com

Steve heeft geschreven in bericht
<7u5s2o$116a$1_at_newssvr04-int.news.prodigy.com>...
>Hi, All:
>
>Can anybody tell me how to find all duplicate records and delete them in
one
>coding? We have thousand of duplicate records needed to be deleted in
>one table (please don't ask why -- unquiue key issue).
>
>Apprecreciated.
>
>Steve
>
>
>
Received on Sun Oct 17 1999 - 12:48:44 CDT