1. create another identical table (lazy way: right-click table, script table as, create to, new query editor window)
  2. rename constraints
  3. create unique index removeduplicates on newtab (uniqfield) with
    IGNORE_DUP_KEY
  4. insert * from oldtab into newtab
    You’ll get a warning “ignoring duplicate field” which is good.