Delete duplicate rows in version table

SreerajanParamanandham — Thu, 07 May 2020 08:38:36 GMT

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

Re: Delete duplicate rows in version table

RandyKreuziger1 — Thu, 14 May 2020 01:21:12 GMT

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.

topic Re: Delete duplicate rows in version table in Developers Questions

Delete duplicate rows in version table

Re: Delete duplicate rows in version table