When you use database management or SQL tools to query a database that contains an enterprise geodatabase, you'll see geodatabase dataset tables. All the tables that compose a single dataset are stored in the schema of the database user who created the dataset.
The tables created for each type of dataset supported in an enterprise geodatabase are listed here so you can identify them. Do not alter these tables using SQL.
Catalog datasets
A catalog dataset is a table in the geodatabase that stores references to other data sources. This allows you to organize data items.
The catalog dataset's object ID is stored in the GDB_ITEMS system table. In the Definition field of the GDB_ITEMS system table, the XML definition stores the value for the Feature Type value is esriFTCatalogDatasetItem.
Feature datasets
Feature datasets are objects that allow you to implement specific geodatabase dataset types, such as networks or topologies. A feature dataset is not a separate table in the database; it is a virtual collection of feature classes and controller (or extension) datasets that are grouped by a common ID. The ID is maintained in the GDB_ITEMS system table. Each feature class is identified as part of the feature dataset through the GDB_ITEMRELATIONSHIPS system table.
Network datasets
Network datasets are collections of feature classes that possess a connectivity relationship. Network datasets are created using three types of sources—edge feature sources, such as street centerlines; junction feature sources, such as point feature classes containing railroad crossings; and turn feature sources. They are used to model transportation.
You cannot create or update network datasets in ArcGIS Pro, but you can view them.
The following tables store network dataset information. The ID in the first six tables is the logical network identifier. The itemID in the last two tables is the object ID of the network in the GDB_ITEMS system table.
- N_<ID>_DESC
- N_<ID>_EDGEWEIGHT
- N_<ID>_JUNCTIONWEIGHT
- N_<ID>_PROPS
- N_<ID>_TOPOLOGY
- N_<ID>_TURNWEIGHT
- ND_<ITEMID>_DIRTYAREAS
- ND_<ITEMID>_DIRTYOBJECTS
Utility networks
A utility network is a set of interrelated tables in an enterprise geodatabase that provides a framework for modeling utility systems such as electric, gas, water, storm water, wastewater, and telecommunications.
You create utility networks in enterprise geodatabases using ArcGIS Pro and publish the networks to an ArcGIS GIS Server site federated with an ArcGIS Enterprise portal. The other members of your organization interact with the network through the portal item, not the layer in the geodatabase.
The following are the tables that compose a utility network. Some of the tables are generated the first time you perform an operation that requires the table's existence. The ID in the table names is the oid value from the GDB_ITEMS system table.
- UN_<ID>_AGGREGATIONS
- UN_<ID>_ASSOCIATIONS
- UN_<ID>_ATTRIBUTEOVERRIDES
- UN_<ID>_CONNECTIVITYOVERRIDES
- UN_<ID>_CONTAINERS
- UN_<ID>_DIAGRAMS
- UN_<ID>_DIRTYAREAS
- UN_<ID>_EDGEWEIGHTS
- UN_<ID>_EDGES
- UN_<ID>_EIDMAPPINGS
- UN_<ID>_ELEMENTASSOCIATIONS
- UN_<ID>_JUNCTIONWEIGHTS
- UN_<ID>_JUNCTIONS
- UN_<ID>_LINEERRORS
- UN_<ID>_POINTERRORS
- UN_<ID>_POLYGONERRORS
- UN_<ID>_PROPS
- UN_<ID>_RELATIONS
- UN_<ID>_RULES
- UN_<ID>_SUBNETWORKS
- UN_<ID>_SYSTEMJUNCTIONS
- UN_<ID>_TEMPLATES
- UN_<ID>_TMPAGGREGATIONS
- UN_<ID>_TMPCONTAINERS
- UN_<ID>_TMPDIAGRAMS
- UN_<ID>_TMPEDGES
- UN_<ID>_TMPJUNCTIONS
- UN_<ID>_TMPRELATIONS
- UN_<ID>_TOPOLOGY
- UN_<ID>_TRACECONFIGURATIONS
- UN_<ID>_WEIGHTDEFS
Trace networks
A trace network is a set of interrelated tables that provides a framework for modeling linear systems such as railroads and hydrology systems.
The following are the tables that compose a trace network. Some of the tables are generated the first time you perform an operation that requires the table's existence. The ID in the table names is the oid value from the GDB_ITEMS system table.
- TN_<ID>_AGGREGATIONS
- TN_<ID>_ASSOCIATIONS
- TN_<ID>_CONTAINERS
- TN_<ID>_DIAGRAMS
- TN_<ID>_DIRTYAREAS
- TN_<ID>_EDGEWEIGHTS
- TN_<ID>_EDGES
- TN_<ID>_EIDMAPPINGS
- TN_<ID>_ELEMENTASSOCIATIONS
- TN_<ID>_JUNCTIONWEIGHTS
- TN_<ID>_JUNCTIONS
- TN_<ID>_LINEERRORS
- TN_<ID>_POINTERRORS
- TN_<ID>_PROPS
- TN_<ID>_RELATIONS
- TN_<ID>_SYSTEMJUNCTIONS
- TN_<ID>_TEMPLATES
- TN_<ID>_TMPAGGREGATIONS
- TN_<ID>_TMPCONTAINERS
- TN_<ID>_TMPDIAGRAMS
- TN_<ID>_TMPEDGES
- TN_<ID>_TMPJUNCTIONS
- TN_<ID>_TMPRELATIONS
- TN_<ID>_TOPOLOGY
- TN_<ID>_TRACECONFIGURATIONS
- TN_<ID>_WEIGHTDEFS
Topologies
Topologies are rules that enforce data integrity and manage the behavior of spatially related feature classes. A geodatabase topology stores information about the feature classes that participate in the topology, the cluster tolerance assigned to the topology, the relative rank of each feature class in the topology, and a list of the rules that apply to that topology.
Topologies are supported on feature datasets that are registered for branch versioning. You must publish the feature dataset and topology as an editable feature service to use the topology. When you validate the topology, the dirty areas and topology errors identified by the validation process are stored in a set of tables in the geodatabase. These tables are owned by the same database user who owns the feature classes that participate in the topology.
The following are the tables that compose a topology. The ID in the table names is the topology identifier stored in the GDB_ITEMS system table.
- T_<ID>_DIRTYAREAS
- T_<ID>_LINEERRORS
- T_<ID>_POINTERRORS
- T_<ID>_POLYERRORS
Mosaic datasets
Multiple tables that store information about the imagery that is stored on disk are used to implement mosaic datasets. A set of properties and rules in the tables defines a real-time mosaic view of the imagery data. The dataset name is the middle part of the system table names.
There can be up to 12 tables in a mosaic dataset. Some of the tables are generated the first time you perform an operation that requires the table's existence. Referenced mosaic datasets only have two tables: the BND and LOG tables. The tables are as follows:
- AMD_<dataset_name>_ANA
- AMD_<dataset_name>_ART
- AMD_<dataset_name>_BND
- AMD_<dataset_name>_CAT
- AMD_<dataset_name>_CCA
- AMD_<dataset_name>_CHE
- AMD_<dataset_name>_CSL
- AMD_<dataset_name>_LOG
- AMD_<dataset_name>_OVR
- AMD_<dataset_name>_SML
- AMD_<dataset_name>_STR
- AMD_<dataset_name>_STS
Note:
The dataset portion of the name will be truncated if the combination of the dataset name and the internal table name would exceed the maximum number of characters that the database allows for table names.
Raster datasets
Raster data is spatial data represented in an array of equally sized cells arranged in rows and columns. Raster data is composed of one or more raster bands. When you create or import a raster dataset, a raster column is added to the base table when it is created in the database. Each cell of the raster column contains a reference to a raster stored in a separate raster table.
Each raster dataset contains a base table that stores attributes, a raster column, and the footprint (the area) of the raster.
Raster images and properties are stored in the following tables:
- SDE_aux_<raster_column_ID>
- SDE_blk_<raster_column_ID>
- SDE_bnd_<raster_column_ID>
- SDE_ras_<raster_column_ID>
- SDE_VAT_<raster_column_ID>—Optional table to define attributes for raster cell values of a raster dataset.
Trajectory datasets
Trajectory datasets store a collection of files and data points that represent the orbital path of a satellite.
In addition to the dataset you see in ArcGIS Pro, four tables in the user's schema store information about each trajectory dataset. The <dataset_name> portion of the system tables is the same as the name of the trajectory dataset.
- AMD_<dataset_name>_ART
- AMD_<dataset_name>_BND
- AMD_<dataset_name>_CAT
- AMD_<dataset_name>_DEF
- AMD_<dataset_name>_LOG
Note:
The dataset portion of the name will be truncated if the combination of the dataset name and the internal table name would exceed the maximum number of characters that the database allows for table names.
Oriented imagery datasets
An oriented imagery dataset is a spatial table that stores a reference to images on disk or in cloud storage. The dataset automatically contains system fields required for the dataset to function. It is a table stored in the schema of the user who creates it.
Toolboxes
Toolboxes store geoprocessing tools and scripts. You can create a toolbox in a geodatabase to store the system geoprocessing tools you use often and custom scripts that you create.
For each toolbox, there will be one table. The table name corresponds to the name of the toolbox.