Thunderstone Support Forums

I have duplicate rows in my table. What would be the best way to remove them?

sql "delete".

If you want to just remove one and leave the other use tsql -l 1 "delete ..."

If there are one or two columns that must never be duplicated across rows, especially a small type like an int, counter or short (<~100 bytes) varchar, you could create a unique index on the column to prevent duplicate insertions in the future.

Thanks for the help