I want to add a unique constraint to a table I am inheriting. The existing table includes duplicates which break the constraint.

I can write SQL to extract the correct data, then save this as a table, then alter the resulting simple table to add constraints, indexes etc. which exist on the existing table ... but that is quite a long process.

Is there an easier way?

Thanks in advance.

Adam


There's not really enough information there. At some point you have to dedup the database. If you can come up with SQL to delete the duplicates then apply the unique constraint it should be faster but that's where the information is lacking.

Roy Lambert [Team Elevate]