Adds table

From Wiki.GIS.com

This article may need to have categories added to fit within wiki.gis.com's taxonomy. You can help. The discussion page may contain suggestions.

This article is missing citations or needs footnotes. Please help add inline citations to guard against copyright violations and factual inaccuracies.

This article needs additional citations for verification. Please help improve this article by adding reliable references. Unsourced material may be challenged and removed.

This article may need to be rewritten entirely to comply with wiki.gis.com's Terms of Use. You can help. The discussion page may contain suggestions.

Adds table usually called the "A" table is part of a Versioned Featureclass. This table gets created when a Featureclass in an ArcSDE Geodatabase is registered as Versioned and is dropped when the same Featureclass in unregistered as Versioned. Once a Featureclass is registered as versioned, all of its inserts/updates go to the adds table immater of which Version is being edited. A Featureclass only has one Adds Table.

The Schema of an Adds table is similar to that of a the Featureclass' base/business table. A Featureclass' Adds table can be identified with its Registration_id from the ArcSDE Repository table named "Table_Registry".

Records from the Adds table move into the Base table when the Geodatabase is compressed. However, one needs to understand the Versioned environment for cases when the records do not move into Base table of the Featureclass.