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 am doing versioning of sde. I have done this using the ArcMap. I want to look at the delta tables in sql server.

In sql, I don't see the delta tables. I just see few tables named as a144.

How do I look at the delta tables?

share|improve this question
You'll want to look at select registration_ID, owner,table_name from sde.table_registry order by table_name or select registration_ID, owner,table_name from sde_table_registry order by table_name to get the ID for your table. – Jay Cummins May 2 '12 at 20:57
Also check out multi-version views: – Jay Cummins May 2 '12 at 20:59

You're looking for the add/delete tables, most likely, which are the tables that follow the format:

  • a<#> (additions)
  • d<#> (deletions)

Any updates to a feature are a deletion followed by an addition. The layer_id and table_name columns in edited sde_table_registry (My mistake, thanks to Jay Cummins, see his comment for a simple query) will give you an idea of how they map to your feature classes.

The deletions table just shows the rowid and the state at which it was deleted. The additions table shows everything with the state at which it was added.

There's a whole wealth of information to peruse at edndoc, this is just a very tiny slice of the pie. Here's the 9.3 arcsde developer help (not sure which one you're working on):

share|improve this answer

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.