Delete duplicate rows in version table

[SreerajanParamanandham]

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

[RandyKreuziger1]

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.