Select to view content in your preferred language

Delete duplicate rows in version table

367
1
05-07-2020 01:38 AM
SreerajanParamanandham
New Contributor

Hi,

I have the task to delete the duplicate rows in version table using SQL script.

Deleting duplicate rows in base table is straight forward than 'A' table

In 'A Table' we usually have the duplicate

Question

Can I filter the duplicates with sde_state_id?

What are the things need to consider while deleting duplicate rows and what are the impacts.

If anyone has done the same before please share the sample script.

Thanks and Regards

Sreerajan P

0 Kudos
1 Reply
RandyKreuziger1
Frequent Contributor

You should never edit the A and D tables.  These are maintained by ArcSDE so you risk corrupting your data by using SQL even on the base tables.  I think you should be investigating why you have duplicate records in the first place.   

0 Kudos