![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
![]() |
Fri, Jul 20 2012 8:47 AM | Permanent Link |
Adam Brett Orixa Systems | 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. |
Fri, Jul 20 2012 10:52 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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] |
This web page was last updated on Wednesday, July 2, 2025 at 06:46 PM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |