Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I haven't really read this anywhere.

What is the proper way of deleting versioned data from an SDE geodatabase to make sure nothing is left behind in the A & D tables?

Do I need to unversion the data before I delete it? Do I need to remove the user versions? Or does it matter?


share|improve this question
up vote 4 down vote accepted

Unversioning removes the A and D tables associated with a single versioned feature class. Any edits not reconciled and posted to the base table will be lost, which appears to be your goal.

share|improve this answer
Okay, but what if I were to not unversion the data and delete it. Would it still do the same thing? Or could there possibly be tables left stranded out there? – ianbroad Mar 19 '14 at 15:50
If you DROP the A & D tables without unversioning, you corrupt your geodatabase. If you use ArcGIS to delete the versioned feature classes it will clean up the instance correctly. – Vince Mar 19 '14 at 16:30

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.