The system tables include tables that maintain information about the feature
classes and feature datasets. The feature class and feature dataset spatial
references, states, and versions are also maintained within the ArcSDE data
dictionary. The ArcSDE data dictionary combines both the ArcSDE system tables,
created by the giomgr process upon initial startup, and the geodatabase system
tables, created with the geodatabase executable.
The tables and views are created and maintained by ArcSDE. They are not designed
for use by external programs. Changing the data within the ArcSDE data
dictionary either by an external program or manually is not supported.
For each ArcSDE instance, ArcSDE creates several system tables within the
ArcSDE user's schema to manage spatial data.
VERSION table |
Maintains information about the
ArcSDE version with which the database expects to operate |
LAYERS table |
Maintains data about each
feature class in the database
more |
GEOMETRY_COLUMNS table |
Contains the feature class
names, its geometry's storage type, and coordinate dimension
more |
RASTER_COLUMNS table |
Contains a list of raster columns stored in the database:
the table and
raster column names, the owner, creation date, description, database
name, configuration keyword, and minimum ID (database name is required
for some DBMS systems) more |
SPATIAL_REFERENCES table |
Contains the coordinate system and floating point to integer
transformation values Internal functions use the parameters of a
spatial reference system to translate and scale each floating point
coordinate of the geometry into 32-bit positive integers prior to
storage. Upon retrieval, the coordinates are restored to their original
external floating point format.
For some DBMSs that use ST_Geometry storage, the
ST_SPATIAL_REFERENCES table or view is used.
|
TABLE_REGISTRY table |
Manages all tables that have
been registered with ArcSDE
Values include an ID, table name, owner, and description
|
VERSIONS table |
Contains the
version metadata Values include a name, owner, status (public or
private), state ID, and description
more |
STATES table |
Contains the
state metadata Values include a state ID, owner, creation and
closing time, state ID of the parent state, and lineage information
more |
MVTABLES_MODIFIED table |
Contains the state and table IDs
modified in a given state
more |
METADATA table |
Contains
ArcSDE metadata; used in conjunction with the LOCATORS table for geocoding.
more |
LOCATORS table |
Stores information relating to
locator objects more |
|