Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Work with Data > Edit Duplicate Data

Edit Duplicate Data

You can locate duplicate rows of data in a table and can either edit the duplicate row or delete it from the table.

To edit duplicate data

Select the Tables node in the Object Explorer.
Right-click a table and select Tasks | Edit Duplicate Data to open a data grid in a new window that displays only duplicate rows of data.
Select one of the following:
- Edit the data so it is no longer a duplicate.
- Select one or more rows and click — to remove those rows.
Click to save your changes.
Click Submit to commit these changes to the database.

Tip: Click Refresh to re-query the database at anytime.

Note: You can also edit duplicated data with Data Cleansing and Data Browser actions.