System tables of a geodatabase in SQL Server
The system tables for a geodatabase enforce geodatabase behavior, store information about the geodatabase, and keep track of the data stored in the geodatabase.
View a diagram of enterprise geodatabase system tables.
![Note Note](rsrc/note.png)
You need Adobe Acrobat Reader to open the file.
The system tables and their contents should not be altered using anything other than ArcGIS software. However, you can use SQL to view the contents of the system tables.
GDB_ITEMRELATIONSHIPS
The GDB_ITEMRELATIONSHIPS table stores information about how objects in the GDB_ITEMS table are related. For example, feature datasets and replicas are tracked in this table.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
objectid |
integer |
Unique identifier for the row |
NOT NULL |
uuid |
uniqueidentifier |
Unique identifier of the item |
NOT NULL |
type |
uniqueidentifier |
Corresponds to UUID in the GDB_ITEMRELATIONSHIPTYPES table |
NOT NULL |
originid |
uniqueidentifier |
Correponds to UUID in the GDB_ITEMS table |
NOT NULL |
destid |
uniqueidentifier |
Corresponds to UUID in the GDB_ITEMS table |
NOT NULL |
properties |
integer |
Bitmask of item properties |
|
attributes |
xml |
Property set representing the attribute pairs |
GDB_ITEMRELATIONSHIPTYPES
The GDB_ITEMRELATIONSHIPTYPES table maintains data on the types of relationships that exist between the objects in the GDB_ITEMS table.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
objectid |
integer |
Unique identifier for the row |
NOT NULL |
uuid |
uniqueidentifier |
Unique identifier of the item |
NOT NULL |
name |
nvarchar(226) |
Name of the relationship type; values include the following:
|
NOT NULL |
forwardlabel |
nvarchar(226) |
Label that describes the relationship from the context of the origin item |
|
backwardlabel |
nvarchar(226) |
Label that describes the relationship from the context of the destination item |
|
origItemtypeid |
uniqueidentifier |
Corresponds to UUID in the GDB_ITEMTYPES table |
|
destItemtypeid |
uniqueidentifier |
Corresponds to UUID in the GDB_ITEMTYPES table |
NOT NULL |
iscontainment |
smallint |
Indicates whether the origin item's existence controls the existence of the destination object |
GDB_ITEMS
Items are any object used in the ArcGIS system that can be indexed and searched, including tables, domains, topologies, and networks. The GDB_ITEMS table maintains information about all the items stored in the geodatabase.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
objectid |
integer |
Unique identifier for the row |
NOT NULL |
uuid |
uniqueidentifier |
Unique identifier of the item |
NOT NULL |
type |
uniqueidentifier |
Corresponds to UUID in the GDB_ITEMTYPES table |
NOT NULL |
name |
nvarchar(226) |
Name of the item (logical) |
|
physicalname |
nvarchar(226) |
Fully qualified name of the item |
|
path |
nvarchar(512) |
The unique relative path to the item |
|
url |
nvarchar(255) |
The associated URL for the item; used with catalog services |
NOT NULL |
properties |
integer |
Bitmask of item properties |
|
defaults |
varbinary(max) |
Information about the item that is independent of the underlying dataset, such as a serialized renderer; a symbol for a feature class; or column widths, colors, or fonts for tables |
NOT NULL |
datasetsubtype1 |
integer |
Indicates the feature type of the table Possible values are as follows for feature classes and raster catalogs:
For relationship classes, the cardinality of the relationship class is stored. Possible values are:
For topologies, this column stores the Topology ID. |
|
datasetsubtype2 |
integer |
Indicates the geometry type of the table Possible values are as follows for feature classes and raster catalogs:
For relationship classes, the value in this column indicates whether the relationship class is attributed. Possible values are 0 = nonattributed, or 1 = attributed. |
|
datasetinfo1 | nvarchar(255) | Stores the shape field name for feature classes | |
datasetinfo2 | nvarchar(255) | Stores information for feature classes that participate in topologies | |
definition |
xml |
Stores information about the item |
|
documentation |
xml |
Data definition of the item (metadata) |
|
iteminfo |
xml |
Storage information for the item, such as symbology, that is independent of the underlying dataset |
|
shape |
geometry |
The spatial extent of the item |
NOT NULL |
GDB_ITEMTYPES
The GDB_ITEMTYPES table stores information on what type of object each item in the GDB_ITEMS table is.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
objectid |
integer |
Unique identifier for the row |
NOT NULL |
uuid |
uniqueidentifier |
Unique identifier of the item |
NOT NULL |
parenttypeid |
nvarchar(226) |
Foreign key to UUID in this (the GDB_ITEMTYPES) table |
NOT NULL |
name |
uniqueidentifier |
Name of the item type; values include the following:
|
NOT NULL |
GDB_REPLICALOG
Each time a replica exports or imports changes, information about the operation is stored in the GDB_REPLICALOG table.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
id |
integer |
Unique identifier for the row |
NOT NULL |
replicaid |
integer |
Corresponds to the objectid field in the GDB_ITEMS table |
NOT NULL |
event |
integer |
Indicates whether an import (1) or an export (2) has been logged |
NOT NULL |
errorcode |
integer |
The error code associated with the event; you can search the developer help to get the description associated with the error. If the event was successful, a success error code is returned. |
NOT NULL |
logdate |
datetime |
The date on which the event occurred |
NOT NULL |
sourcebegingen |
integer |
Several generations of data changes may be imported or exported in one event. This value indicates the generation number of the first generation of changes involved. For example, if generations 1 to 3 were imported, this field would have the value 1. |
NOT NULL |
sourceendgen |
integer |
Several generations of data changes may be imported or exported in one event. This value indicates the generation number of the last generation of changes involved. For example, if generations 1 to 3 were imported, this field would have the value 3. |
NOT NULL |
targetgen |
integer |
The generation to which changes are to be applied; this value is used to apply changes to the appropriate version in the target replica. |
NOT NULL |
GDB_TABLES_LAST_MODIFIED
The GDB_TABLES_LAST_MODIFIED table is used to validate geodatabase system tables when cached by the client application.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
table_name |
nvarchar(160) |
Name of the geodatabase system table that was modified |
NOT NULL |
last_modified_count |
integer |
Keeps a count of the number of times a system table is modified; incrementally increases for each modification |
NOT NULL |
SDE_archives
The SDE_archives table stores the metadata for the archives in a geodatabase.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
archiving_regid |
integer |
The registration ID of the business table |
NOT NULL |
history_regid |
integer |
The registration ID of the archive table |
NOT NULL |
from_date |
nvarchar(32) |
The name of the from date field |
NOT NULL |
to_date |
nvarchar(32) |
The name of the to date field |
NOT NULL |
archive_date |
bigint |
The date the archive was created |
NOT NULL |
archive_flags |
bigint |
Not currently used |
NOT NULL |
SDE_column_registry
The SDE_column_registry table manages all registered columns.
![Caution Caution](rsrc/caution.png)
If you alter column definitions using a SQL interface, the records in the SDE_column_registry table are not updated. This may cause any subsequent exports of the data to fail.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
database_name |
nvarchar(32) |
Name of the database in which the table containing the column is stored |
NOT NULL |
table_name |
nvarchar(128) |
Name of the table that contains the registered column |
NOT NULL |
owner |
nvarchar(32) |
Owner of the table in which the column resides (the user who created the table) |
NOT NULL |
column_name |
nvarchar(32) |
Name of the registered column |
NOT NULL |
sde_type |
integer |
Code for the column's data type; possible values and their definitions include the following:
|
|
column_size |
integer |
The length of the registered column value |
|
decimal_digits |
integer |
Number of integers to the right of the decimal in the column value |
|
description |
nvarchar(65) |
A description of the type of column |
|
object_flags |
integer |
Stores the column properties, which include the following:
|
NOT NULL |
object_id |
integer |
Set to rastercolumn_id of the SDE_raster_columns table if the column is a raster column or layer_id of the SDE_layers table if this column is a geometry column |
SDE_compress_log
The SDE_compress_log table tracks all compress operations performed on the geodatabase.
![Note Note](rsrc/note.png)
This table is created the first time you compress the geodatabase.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
compress_id |
integer |
Unique identifier of a compress operation |
NOT NULL |
sde_id |
integer |
Process identification number of the compress operation; references sde_id column in SDE_process_information table |
NOT NULL |
server_id |
integer |
System process ID of the ArcSDE server process that performed or is performing the compress operation |
NOT NULL |
direct_connect |
varchar(1) |
Y (yes) or N (no) if the client is making a direct connection to the geodatabase |
NOT NULL |
compress_start |
datetime |
The date and time the compress operation started |
NOT NULL |
start_state_count |
integer |
The number of states present when compress started |
NOT NULL |
compress_end |
datetime |
The date and time the compress operation completed |
NOT NULL |
end_state_count |
integer |
The number of remaining states after the compress operation |
NOT NULL |
compress_status |
nvarchar(20) |
Indicates whether or not the compress operation completed successfully |
NOT NULL |
SDE_dbtune
The SDE_dbtune table stores the configuration keywords forArcSDE data objects, such as feature classes.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
keyword |
nvarchar(32) |
The configuration keyword |
NOT NULL |
parameter |
nvarchar(32) |
The configuration parameter |
NOT NULL |
config_string |
nvarchar(2048) |
The value of the configuration parameter |
NOT NULL |
SDE_geometry_columns
The SDE_geometry_columns table stores a row for each column of type geometry in the database that complies with the OpenGIS SQL specification. ArcSDE treats this table as write-only—the only time it is accessed by ArcSDE is when a layer is added or deleted that uses an OpenGIS SQL data format. This table is defined by the OpenGIS SQL specification and may be updated by other applications with geometry columns not managed by ArcSDE. When a new Geometry column is created in an OpenGIS compliant format, the fully qualified table, column name, and spatial reference ID (srid) are added to the SDE_geometry_columns table.
Each geometry column is associated with a spatial reference system. Information on each spatial reference system is stored in the SDE_spatial_references table.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
f_table_catalog |
nvarchar(32) |
The database in which the feature table is stored |
NOT NULL |
f_table_schema |
nvarchar(32) |
Schema in which the business table is stored |
NOT NULL |
f_table_name |
sysname |
Name of the business table of the dataset |
NOT NULL |
f_geometry_column |
nvarchar(32) |
Name of the geometry column in the business table |
NOT NULL |
g_table_catalog |
nvarchar(32) |
The database in which the geometry column is stored |
|
g_table_schema |
nvarchar(32) |
Schema in which the table that contains the geometry column is stored |
NOT NULL |
g_table_name |
sysname |
Name of the table that contains the geometry column |
NOT NULL |
storage_type |
integer |
Code for the storage type of the geometry; could represent either WKB, WKT, or BINARY |
|
geometry_type |
integer |
Code for the geometry type that the column stores; could represent either point, multipoint, linestring, multilinestring, polygon, or multipolygon |
|
coord_dimension |
integer |
Code for the coordinate dimension:
|
|
max_ppr |
integer |
Maximum points per row (no longer used by ArcSDE) |
|
srid |
integer |
Spatial reference ID |
NOT NULL |
SDE_layer_locks
The SDE_layer_locks table maintains the locks on feature classes.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
sde_id |
integer |
Process identification number of the process that has locked the layer; foreign key to the sde_id column in SDE_process_information table |
NOT NULL |
layer_id |
integer |
Foreign key to layer_id field in SDE_layers table |
NOT NULL |
autolock |
character(1) |
Set to 1 if the layer lock was set internally; otherwise, set to 0 if the layer lock was set by the application. |
|
lock_type |
character(1) |
The type of layer lock can be one of the following:
|
NOT NULL |
minx |
bigint |
The minimum x-coordinate of the bounding box used to define the features within an area locked during an area lock |
|
miny |
bigint |
The minimum y-coordinate of the bounding box used to define the features within an area locked during an area lock |
|
maxx |
bigint |
The maximum x-coordinate of the bounding box used to define the features within an area locked during an area lock |
|
maxy |
bigint |
The maximum y-coordinate of the bounding box used to define the features within an area locked during an area lock |
|
lock_time | datetime | The date and time the layer lock was acquired | NOT NULL |
SDE_layer_stats
The SDE_layer_stats table is no longer used.
SDE_layers
The SDE_layers table maintains data about each feature class in the database. The information helps build and maintain spatial indexes, ensure proper shape types, maintain data integrity, and store the spatial reference for the coordinate data.
This table stores a row for each spatial column in the database. Applications use the layer properties to discover available spatial data sources. The layer properties are used by ArcSDE to constrain and validate the contents of the spatial column, index geometry values, and properly create and manage the associated DBMS tables.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
layer_id |
integer |
The unique identifier for the layer |
NOT NULL |
description |
nvarchar(65) |
User-defined description of the layer |
|
database_name |
nvarchar(32) |
Name of the database in which the layer is stored |
NOT NULL |
table_name |
sysname |
Name of the business table of the layer |
NOT NULL |
owner |
nvarchar(32) |
The user who created the layer |
NOT NULL |
spatial_column |
nvarchar(32) |
Name of the spatial column in the layer |
NOT NULL |
eflags |
integer |
Stores the following layer properties:
|
NOT NULL |
layer_mask |
integer |
Stores additional internal properties about the layer |
NOT NULL |
gsize1 |
float |
Size of first spatial grid |
NOT NULL |
gsize2 |
float |
Size of second spatial grid |
NOT NULL |
gsize3 |
float |
Size of third spatial grid |
NOT NULL |
minx |
float |
Minimum x-coordinate value of the layer |
NOT NULL |
miny |
float |
Minimum y-coordinate value of the layer |
NOT NULL |
maxx |
float |
Maximum x-coordinate value of the layer |
NOT NULL |
maxy |
float |
Maximum y-coordinate value of the layer |
NOT NULL |
minz |
float |
Minimum z-coordinate value of the layer |
|
maxz |
float |
Maximum z-coordinate value of the layer |
|
minm |
float |
Minimum m-coordinate value of the layer |
|
maxm |
float |
Maximum m-coordinate value of the layer |
|
cdate |
integer |
The date the layer was created |
NOT NULL |
layer_config |
nvarchar(32) |
The configuration keyword that was specified when the layer was created |
|
optimal_array_size |
integer |
Geometry array buffer size |
|
stats_date |
The date statistics were last calculated for a layer |
||
minimum_id |
integer |
The minimum feature ID value of a binary layer |
|
srid |
integer |
Spatial reference identification number; corresponds to srid value in the SDE_spatial_references table |
NOT NULL |
base_layer_id |
integer |
Stores the base layer's layer_id value for a layer that is actually a view |
|
secondary_srid |
integer |
Used to store high-precision coordinate reference to project data when the data was basic precision and was converted to high precision |
SDE_lineages_modified
The SDE_lineages_modified table contains a state lineage ID and its most recent modification time stamp.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
lineage_name |
bigint |
Corresponds to the lineage_name field in the SDE_state_lineages table |
NOT NULL |
time_last_modified |
datetime |
The date and time the lineage was last modified |
NOT NULL |
SDE_locators
The SDE_locators table stores information about locator objects.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
locator_id |
integer |
Unique identifier of the locator |
NOT NULL |
name |
nvarchar(32) |
The name of the locator |
NOT NULL |
owner |
nvarchar(32) |
The name of the user who owns the locator |
NOT NULL |
category |
nvarchar(32) |
The category of the locator; address locators have a category value of Address |
NOT NULL |
type |
integer |
The type of locator; values represented as follows:
|
NOT NULL |
description |
nvarchar(64) |
The description of the locator |
SDE_logfile_pool
The SDE_logfile_pool table will be present in the geodatabase when it is first created, regardless of what type of log files you use. For a description of this and other log file tables, see Log file tables in a geodatabase in SQL Server.
SDE_metadata
When you add a locator to a geodatabase in a DBMS, a row is added to the SDE_metadata table for each property of the locator.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
record_id |
integer |
Unique identifier for the record |
NOT NULL |
object_database |
nvarchar(32) |
The name of the database in which the locator is stored |
|
object_name |
nvarchar(160) |
The name of the locator to which the property belongs and foreign key to the name column in the SDE_locators table |
NOT NULL |
object_owner |
nvarchar(32) |
The name of the user who owns the record |
NOT NULL |
object_type |
integer |
Always a value of 2 for locator properties |
NOT NULL |
class_name |
nvarchar(32) |
Always a value of SDE_internal for locator properties |
|
property |
nvarchar(32) |
The name of the locator property |
|
prop_value |
nvarchar(255) |
The value of the locator property |
|
description |
nvarchar(65) |
Not used for locator properties |
|
creation_date |
datetime |
Date and time the locator property was created |
NOT NULL |
SDE_mvtables_modified
The SDE_mvtables_modified table maintains the list of all tables that are modified in each state of the database. This information aids in quickly determining if conflicts exist between versions or states of the database.
The SDE_mvtables_modified table maintains a record of all tables modified by state. This information allows applications to determine which tables need to be checked for changes when reconciling potential conflicts between versions and states in the database.
Any time a feature class or table is modified in a state, a new entry is created in the SDE_mvtables_modified table. When two versions are reconciled, the first step in the process is to identify the states these two versions reference—the current edit version’s state and the target version’s state. From these states, a common ancestor state is identified by tracing back through the state lineage of these two versions.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
state_id |
bigint |
The identifier of the state in which this table was modified; foreign key to the state_id field in the SDE_states table |
NOT NULL |
registration_id |
integer |
The registration ID of the table that was modified in the state; foreign key to the SDE_table_registry table |
NOT NULL |
SDE_object_locks
The SDE_object_locks table maintains locks on geodatabase objects.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
sde_id |
integer |
Process identification number of the process that locked the geodatabase object; references sde_id column in SDE_process_information table |
NOT NULL |
object_id |
integer |
ID of the affected dataset from the GDB_ITEMS table |
NOT NULL |
object_type |
integer |
Object lock type, for example, version,state_tree lock used by internal applications |
NOT NULL |
application_id |
integer |
Application unique identifier |
NOT NULL |
autolock |
character(1) |
Set to 1 if the layer lock was set internally; otherwise, set to 0, which means the layer lock was set by the application |
NOT NULL |
lock_type |
character(1) |
The type of object lock: S = shared or E = exclusive |
NOT NULL |
lock_time | datetime | The date and time the object lock was acquired | NOT NULL |
SDE_process_information
The SDE_process_information table collects ArcSDE session statistics such as the number of records read and the number of records written while the session was active.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
sde_id |
integer |
Process identification number |
NOT NULL |
spid |
integer |
The gsrvr process ID |
NOT NULL |
server_id |
integer |
The operating system process ID of the server process |
NOT NULL |
start_time |
datetime |
Date and time process was started |
NOT NULL |
rcount |
integer |
The number of reads that have been processed |
NOT NULL |
wcount |
integer |
The number of writes that have been processed |
NOT NULL |
opcount |
integer |
Total number of operations a process has executed |
NOT NULL |
numlocks |
integer |
The number of locks that the process currently has open |
NOT NULL |
fb_partial |
integer |
Total number of partial features shipped by the process |
NOT NULL |
fb_count |
integer |
Total number of buffers loaded by the process |
NOT NULL |
fb_fcount |
integer |
Total number of features buffered by the process |
NOT NULL |
fb_kbytes |
integer |
Total number of kilobytes buffered by the process |
NOT NULL |
owner |
nvarchar(30) |
The name of the connected user |
NOT NULL |
direct_connect |
varchar(1) |
Indicates whether process was made with a direct connection: T (true) or F (false) |
NOT NULL |
sysname |
nvarchar(32) |
The operating system that the client machine is running |
NOT NULL |
nodename |
nvarchar(255) |
The connected client machine name |
NOT NULL |
xdr_needed |
varchar(1) |
Records whether client is using XDR to communicate with the gsrvr: T (true) or F (false) |
NOT NULL |
table_name |
nvarchar(95) |
Name of internal temporary table used for the session |
NOT NULL |
SDE_raster_columns
The SDE_raster_columns table contains a list of raster columns stored in the database.
This table references the raster data in the band, block, and auxiliary tables.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
rastercolumn_id |
integer |
The primary key of the raster column table |
NOT NULL |
description |
nvarchar(65) |
The user-defined description of the raster table |
|
database_name |
nvarchar(32) |
Name of the database in which the raster is stored |
NOT NULL |
owner |
nvarchar(32) |
The owner of the raster column's business table |
NOT NULL |
table_name |
sysname |
The business table name |
NOT NULL |
raster_column |
nvarchar(32) |
The raster column name |
NOT NULL |
cdate |
integer |
The date the raster column was added to the business table |
NOT NULL |
config_keyword |
nvarchar(32) |
The DBTUNE configuration keyword specified when the raster was created; determines how the tables and indexes of the raster are stored in the database |
|
minimum_id |
integer |
Defined during the creation of the raster, establishes value of the raster table's raster_id column |
|
base_rastercolumn_id |
integer |
When the raster column is part of a view and not a table, is the rastercolumn_id of the base table of the view |
NOT NULL |
rastercolumn_mask |
integer |
Set to 256 for a geodatabase raster |
NOT NULL |
srid |
integer |
Spatial reference identifier number, references srid in the SDE_spatial_references table |
SDE_server_config
The SDE_server_config table stores ArcSDE server configuration parameters. These parameters define how the ArcSDE software uses memory.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
prop_name |
nvarchar(32) |
The initialization parameter name |
NOT NULL |
char_prop_value |
nvarchar(512) |
The character value of the initialization parameter |
NOT NULL |
num_prop_value |
integer |
The integer value of the initialization parameter |
NOT NULL |
SDE_spatial references
The SDE_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 64-bit positive integers prior to storage. Upon retrieval, the coordinates are restored to their original external floating-point format.
Each geometry column of the SDE_geometry_columns table is associated with a spatial reference system, the information for which is stored in the SDE_spatial_references table. The columns of this table are those defined by the OpenGIS SQL Specification (srid, srtext, auth_name, and auth_srid) and those required by ArcSDE for internal coordinate transformation. The spatial reference system identifies the coordinate system for a geometry and gives meaning to the numeric coordinate values for the geometry.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
srid |
integer |
Spatial reference identifier |
NOT NULL |
description |
nvarchar(64) |
The text description of the spatial reference system |
|
auth_name |
nvarchar(255) |
The name of the standard or standards body that is being cited for this reference system; for example, POSC would be a valid auth_name |
|
auth_srid |
integer |
The ID of the spatial reference system as defined by the authority cited in auth_name |
|
falsex |
float |
The x offset used when transforming ground coordinates to internal system coordinates |
NOT NULL |
falsey |
float |
The y offset used when transforming ground coordinates to internal system coordinates |
NOT NULL |
xyunits |
float |
The scale factor to apply when transforming ground coordinates to internal system coordinates |
NOT NULL |
falsez |
float |
The z offset to use when transforming z values to internal system coordinates |
NOT NULL |
zunits |
float |
The scale factor to use when transforming z values to internal system coordinates |
NOT NULL |
falsem |
float |
The measure offset to use when transforming measure values to internal system coordinates |
NOT NULL |
munits |
float |
The scale factor to use when transforming measure values to internal system coordinates |
NOT NULL |
xycluster_tol |
float |
Xy-coordinate cluster tolerance for topological processing |
|
zcluster_tol |
float |
Z-coordinate cluster tolerance for topological processing |
|
mcluster_tol |
float |
Measure cluster tolerance for topological processing |
|
object_flags |
integer |
Stores object attributes, including precision |
NOT NULL |
srtext |
nvarchar(1024) |
Name and descriptor for the spatial reference as seen in the ArcGIS interface |
NOT NULL |
SDE_state_lineages
The SDE_state_lineages table stores the lineage of each state. A new lineage name is created for each version. Each time a state is added, the lineage name and the state ID are added. When a state is added that is a new version, the ancestry state lineage of the parent state is added with the lineage name.
To return the correct view of a version, its states lineage is queried to identify all the states that recorded each change made to that version. From this list of states, the table rows that correctly represent the version can be determined.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
lineage_name |
bigint |
Name that describes a state |
NOT NULL |
lineage_id |
bigint |
Unique identifier of individual states |
NOT NULL |
SDE_state_locks
The SDE_state_locks table maintains the version state locks.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
sde_id |
integer |
Process identification number of the process that locked the state; references sde_id column in SDE_process_information table |
NOT NULL |
state_id |
bigint |
Identifier of the state that is locked |
NOT NULL |
autolock |
character(1) |
Set to 1 if the layer lock was set internally; otherwise, set to 0 if the layer lock was set by the application |
NOT NULL |
lock_type |
character(1) |
The type of state lock; the following are possible types:
|
NOT NULL |
lock_time | datetime | The date and time the state lock was acquired | NOT NULL |
SDE_states
The SDE_states table contains the state metadata. It accounts for the states that have been created over time, and the creation time, closing time, parent, and owner of each state.
When a state is created, a state ID is assigned and a record is added to this table.
Field name |
Field type |
Discussion |
Null? |
---|---|---|---|
state_id |
bigint |
A unique identifier for this state, assigned by ArcSDE |
NOT NULL |
owner |
nvarchar(32) |
The user who created this state |
NOT NULL |
creation_time |
datetime |
The date and time this state was created |
NOT NULL |
closing_time |
datetime |
The date and time this state was closed |
|
parent_state_id |
bigint |
This state_id of the parent state |
NOT NULL |
lineage_name |
bigint |
References the state's lineage name stored in the SDE_state_lineages table |
NOT NULL |
SDE_table_locks
The SDE_table_locks table maintains the locks on ArcSDE registered tables.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
sde_id |
integer |
Process identification number of the process that locked the table; references sde_id column in SDE_process_information table |
NOT NULL |
registration_id |
integer |
Foreign key to registration_id field in the SDE_table_registry table |
NOT NULL |
lock_type |
character(1) |
The type of table lock
|
NOT NULL |
lock_time | datetime | The date and time the table lock was acquired | NOT NULL |
SDE_table_registry
The SDE_table_registry table manages all registered tables. The values include an ID, table name, owner, and description.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
registration_id |
integer |
Unique identifier for the registration of the table |
NOT NULL |
database_name |
nvarchar(32) |
Name of the database in which the table is stored |
NOT NULL |
table_name |
sysname |
Name of the table |
NOT NULL |
owner |
nvarchar(32) |
User who created the table |
NOT NULL |
rowid_column |
nvarchar(32) |
Name of the ObjectID column in the table |
NOT NULL |
description |
nvarchar(65) |
The user-defined text description of the table |
|
object_flags |
integer |
Stores the registration properties of the table, which include the following:
|
NOT NULL |
registration_date |
integer |
The date the table was registered with ArcSDE |
NOT NULL |
config_keyword |
nvarchar(32) |
Configuration keyword specified when the table was registered with ArcSDE; determines the storage of the table and its indexes in the database |
|
minimum_id |
integer |
The minimum row_id value of the table |
|
imv_view_name |
nvarchar(32) |
The name of the versioned view defined on the table (if the table is registered as versioned) or the name of the view created for the nonversioned table when it is enabled for archiving |
SDE_tables_modified
The SDE_tables_modified table records when changes are made to the system tables. This information is used to eliminate unnecessary reads of tables that have not changed.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
table_name |
sysname |
Name of the ArcSDE system table that was modified |
NOT NULL |
time_last_modified |
datetime |
Date and time the table was modified |
NOT NULL |
SDE_version
The SDE_version table maintains information about the version of ArcSDE with which the database expects to operate. The table contains the specific release identification for the most recently installed version of ArcSDE.
The SDE_version table and other ArcSDE system tables are updated after a new version of ArcSDE is installed.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
major |
integer |
Number of the major release; for example, for ArcSDE 9.3, the major release number is 9. |
NOT NULL |
minor |
integer |
Number indicating the version of the minor release; for example, for ArcSDE 9.3, the minor release number is 3. |
NOT NULL |
bugfix |
integer |
Number of the patch or service pack installed |
NOT NULL |
description |
nvarchar(96) |
System-defined description of the ArcSDE installation |
NOT NULL |
release |
integer |
Complete release number, for example, 92009 |
NOT NULL |
sdesvr_rel_low |
integer |
Indicates the lowest release number of server allowed to run on this instance |
NOT NULL |
SDE_versions
The SDE_versions table contains information about versioned geodatabases.
Each version is identified by a name, with an owner, description, and associated database state. This table defines the different versions that the database contains and provides a list of available versions to be presented to the user. These versions are used to access specific database states by the application. The version name and ID are unique.
When the SDE_versions table is first created by ArcSDE, a default version is inserted into the table. This default version is named DEFAULT, is owned by the ArcSDE administrator, and is granted PUBLIC access. The initial state_id is set to 0, and the description string reads Instance Default Version. Since the default version has been granted PUBLIC access, any user can change the state of the default.
ArcGIS requires the presence of the default version. If you should inadvertently delete the default version, you can replace it with the following SQL INSERT statement:
INSERT INTO sde_versions VALUES
('DEFAULT','SDE',1,1,0,'Instance default version.',null,null,null,GETDATE())
Field_name |
Field type |
Description |
Null? |
---|---|---|---|
name |
nvarchar(64) |
The unique name of the version |
NOT NULL |
owner |
nvarchar(32) |
The version owner |
NOT NULL |
version_id |
integer |
The unique identifier of the version |
NOT NULL |
status |
integer |
Specifies whether the version is available to the public or if it is privately accessed by the owner |
NOT NULL |
state_id |
bigint |
The identifier of the database state to which this version points |
NOT NULL |
description |
nvarchar(64) |
An optional text description of the version |
|
parent_name |
nvarchar(64) |
The name of the parent of this version |
|
parent_owner |
nvarchar(32) |
The name of the owner of the parent version |
|
parent_version_id |
integer |
The identifier of the version that is the parent of this version |
|
creation_time |
datetime |
The date and time that this version was created |
NOT NULL |
SDE_xml_columns
When you add an ArcSDE XML column to a business table, a row is added to the XML columns table. This table occurs once in each ArcSDE geodatabase.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
column_id |
integer |
The XML column's identifier; assigned by ArcSDE at the time the XML column is created |
NOT NULL |
registration_id |
integer |
The identifier of the business table containing the XML column; corresponds to the id column in the SDE_table registry table |
NOT NULL |
column_name |
nvarchar(32) |
Name of the XML column in the business table |
NOT NULL |
index_id |
integer |
The identifier of the XPath index associated with the XML column, if one exists; a foreign key to the XML indexes table |
|
minimum_id |
integer |
The value of the initial number used in the business table's XML column to identify individual XML documents |
|
config_keyword |
nvarchar(32) |
The DBTUNE configuration keyword containing parameters that determine how the XML document and the XML XPath index tables and the text indexes created on those tables are defined in the database |
|
xflags |
integer |
A value indicating whether the original documents in the XML document table are stored compressed or decompressed; compressed by default (Compressed documents provide better performance.) |
NOT NULL |
SDE_xml_index_tags
An ArcSDE XML column can optionally have an XPath index, which lets people search the content of a specific XML element or attribute in each document. The definition of which elements and attributes are included in or excluded from each XPath index is recorded in this table.
This table occurs once in each ArcSDE database. It contains one row for each XPath associated with the XPath index of an ArcSDE XML column.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
index_id |
integer |
The identifier of the XPath index associated with an ArcSDE XML column, if one exists; foreign key to the XML indexes table |
NOT NULL |
tag_id |
integer |
The identifier of an XPath or tag |
NOT NULL |
tag_name |
nvarchar(1024) |
An absolute XPath identifying an XML element or attribute that may occur in an XML document (For example, /metadata/mdDateSt identifies an XML element, and /metadata/dataIdInfo/tpCat/TopicCatCd/@value identifies an XML attribute. These XPaths must not contain asterisks [*] to refer to a group of XML elements or attributes—each element or attribute is matched exactly using the XPaths specified in this table.) |
NOT NULL |
data_type |
integer |
A value indicating whether the XML element or attribute will be indexed as a string or a number
|
NOT NULL |
tag_alias |
integer |
A number that can be used to identify an XPath (For example, the Z39.50 communication protocol uses numeric codes to refer to content that may be searched. This column is not used by the ArcIMS Z39.50 Connector.) |
|
description |
nvarchar(64) |
Text identifying the content that should be contained in the XML element or attribute |
|
is_excluded |
integer |
A value indicating whether the XML element is included in or excluded from the XPath index
|
NOT NULL |
SDE_xml_indexes
This table occurs once in each ArcSDE database. It contains one row for each ArcSDE XML column that has an XPath index.
Field name |
Field type |
Description |
Null? |
---|---|---|---|
index_id |
integer |
The identifier of the XPath index |
NOT NULL |
index_name |
nvarchar(32) |
The name of the XPath index For XPath indexes associated with an ArcIMS Metadata Service, the name will be ims_xml#, where # is the identifier of the XML column in the Metadata Service's business table. |
NOT NULL |
owner |
nvarchar(32) |
The database user who owns the XML column For ArcIMS Metadata Services, this is the user specified in the service's ArcXML configuration file. |
NOT NULL |
index_type |
integer |
A value indicating the type of XPath index
|
NOT NULL |
description |
nvarchar(64) |
Text identifying the XPath index If an index definition file was used to create the index, the index's description might be specified at the top of the file. |