NOTE: The system tables should not be altered using anything other than the ArcGIS software.
NOTE: If you alter column definitions using a SQL interface, the records in the COLUMN_REGISTRY table are not updated. This may cause any subsequent exports of the data to fail.
Field name |
Field type |
Description |
DATABASE_NAME |
VARCHAR(32) |
Name of the database in which the table containing the column resides
NOT NULL |
TABLE_NAME |
VARCHAR(128) |
Name of the table that contains the registered column
NOT NULL |
OWNER |
VARCHAR(32) |
Owner of the table in which the column resides (the user who created the table)
NOT NULL |
COLUMN_NAME |
VARCHAR(32) |
Name of the registered column
NOT NULL |
SDE_TYPE |
INTEGER |
Code for the column's data type; possible values and their definitions include
1 = SE_INT16_TYPE—2-byte Integer
2 = SE_INT32_TYPE —4-byte Integer
3 = SE_FLOAT32_TYPE—4-byte Float
4 = SE_FLOAT64_TYPE—8-byte Float
5 = SE_STRING_TYPE—Null Term. Character Array
6 = SE_BLOB_TYPE—Variable Length Data
7 = SE_DATE_TYPE—Struct tm Date
8 = SE_SHAPE_TYPE—Shape geometry (SE_SHAPE)
9 = SE_RASTER_TYPE—Raster
10 = SE_XML_TYPE—XML Document
11 = SE_INT64_TYPE—8-byte Integer
12 = SE_UUID_TYPE—A Universal Unique ID
13 = SE_CLOB_TYPE—Character variable length data
14 = SE_NSTRING_TYPE—UNICODE Null Term. Character Array
15 = SE_NCLOB_TYPE—UNICODE Character Large Object
20 = SE_POINT_TYPE—Point UDT
21 = SE_CURVE_TYPE—LineString UDT
22 = SE_LINESTRING_TYPE—LineString UDT
23 = SE_SURFACE_TYPE—Polygon UDT
24 = SE_POLYGON_TYPE— Polygon UDT
25 = SE_GEOMETRYCOLLECTION_TYPE 25 /* MultiPoint UDT */
26 = SE_MULTISURFACE_TYPE—LineString UDT
27 = SE_MULTICURVE_TYPE—LineString UDT
28 = SE_MULTIPOINT_TYPE—MultiPoint UDT
29 = SE_MULTILINESTRING_TYPE—MultiLineString UDT
30 = SE_MULTIPOLYGON_TYPE—MultiPolygon UDT
31 = SE_GEOMETRY_TYPE—Geometry UDT
NOT NULL |
COLUMN_SIZE |
INTEGER |
The registered column value's length |
DECIMAL_DIGITS |
INTEGER |
Number of integers to the right of the decimal in the column value |
DESCRIPTION |
VARCHAR(65) |
A description of the type of column
|
OBJECT_FLAGS |
INTEGER |
Stores the column properties; properties include
- Column has a row ID.
- SDE controls the row ID column.
- Column allows NULLS.
- Column stores Oracle LONG RAW data.
- Column stores BLOB data.
- Column stores CLOB data.
- Column stores ST_GEOMETRY geometry data.
- Column stores binary geometry data.
- Column stores UDT geometry data.
- Column stores Oracle LOB geometry data.
- Column stores binary raster data.
- Column stores UDT raster data.
- Column stores XML data.
- Column stores dates.
- Column stores time.
- Column stores a time stamp.
- Column stores a Unicode string.
NOT NULL |
OBJECT_ID |
INTEGER |
Set to the RASTERCOLUMN_ID of the RASTER_COLUMNS table if the column is a raster column or the LAYER_ID of the LAYERS table if this column is a geometry column
|
NOTE: This table is not present if the geodatabase has never been compressed.
Field name |
Field type |
Description |
COMPRESS_ID |
INTEGER |
Unique ID of a compress operation
NOT NULL |
SDE_ID |
INTEGER |
Process identification number of the compress operation; references sde_id column in 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 |
TIMESTAMP |
The date and time the compress operation was begun
NOT NULL |
START_STATE_COUNT |
INTEGER |
The number of states present when compress began
NOT NULL |
COMPRESS_END |
TIMESTAMP |
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 |
VARCHAR(20) |
Indicates whether or not the compress operation was successfully completed
NOT NULL |
Field name |
Field type |
Description |
ID |
INTEGER |
Unique identifier of the domain.
Primary key.
NOT NULL. |
OWNER |
VARCHAR(32) |
User who created the attribute domain.
NOT NULL. |
DOMAINNAME |
VARCHAR(160) |
Name assigned to the attribute domain in the geodatabase.
NOT NULL. |
DESCRIPTION |
VARCHAR(255) |
Optional text describing the attribute domain. |
DOMAINTYPE |
INTEGER |
Code indicating whether this is a range (1) or coded value (2) domain. |
FIELDTYPE |
INTEGER |
Code indicating what type of field the domain applies to.
0 = Short integer
1 = Long integer
2 = Float
3 = Double
4 = Text
5 = Date |
MERGEPOLICY |
INTEGER |
Code indicating the policy to assign to the resultant feature when two features are merged.
1 = sum values—The attribute of the feature that results from a merge will be the sum of the values of the two original (premerge) features.
2 = geometry weighted—The attribute of the feature that results from a merge is the weighted average of the values of the attributes of the original (premerge) features. The average is based on the original features' geometry.
3 = default value—The attribute of the feature created as a result of the merge will be the same as the default value of the feature class or subtype. (Note: This is the only merge policy value available for nonnumeric fields and coded value domains.) |
SPLITPOLICY |
INTEGER |
Code indicating the policy to be used for assigning attributes to the features that result from splitting one feature.
1 = geometry ratio—The attributes of the features resulting from the split are a ratio of the original feature's (presplit) value. The ratio is based on the ratio in which the geometry is divided by the split.
2 = duplicate—The attribute of the features resulting from the split are the same as the original object's (presplit) attribute value.
3 = default value—The attributes of features resulting from the split take on the default value for the attribute as defined in the feature class or subtype. |
Field name |
Field type |
Description |
OBJECTCLASSID |
INTEGER |
Foreign key to the ID field in the GDB_OBJECTCLASSES table
NOT NULL |
FEATURETYPE |
INTEGER |
Code representing the type of feature
1 = point, multipoint, line, polygon, or multipatch
7 = junctions
8 = simple edges
10 = complex edges
11 = annotation
13 = dimension
14 = raster
NOT NULL |
GEOMETRYTYPE |
INTEGER |
Code representing the type of geometry of the feature class
1 = point
2 = multipoint
3 = line
4 = polygon (including anno and dimension)
9 = multipatch
NOT NULL |
SHAPEFIELD |
VARCHAR(32) |
Name of the shape field in the feature class
NOT NULL |
GEOMNETWORKID |
INTEGER |
Foreign key to ID field in the GDB_GEOMNETWORKS table |
GRAPHID |
INTEGER |
Foreign key to ID GDB_NETWORKS table |
Field name |
Field type |
Description |
CLASSID |
INTEGER |
Foreign key to the ID field in the GDB_OBJECTCLASSES table
NOT NULL |
FIELDNAME |
VARCHAR(160) |
Name of the field in the table
NOT NULL |
ALIASNAME |
VARCHAR(160) |
Alternate name assigned to the field (Aliases can be altered after field creation; the field name cannot.) |
MODELNAME |
VARCHAR(160) |
Alternate name assigned to the field used to identify a type of field without requiring a hard-coded name |
DEFAULTDOMAINNAME |
VARCHAR(160) |
Name of the domain associated with the field |
DEFAULTVALUESTRING |
VARCHAR(160) |
If the field is type text, the default value assigned to it |
DEFAULTVALUENUMBER |
DECIMAL |
If the field is a numeric type, the default value assigned to it |
ISREQUIRED |
INTEGER |
0 (is not a required field) or 1 (is a required field)
NOT NULL |
ISSUBTYPEFIXED |
INTEGER |
Denotes whether subtype is set for the field
0 = yes
1 = no
NOT NULL |
ISEDITABLE |
INTEGER |
0 (not editable) or 1 (editable)
NOT NULL |
Field name |
Field type |
Description |
RULEID |
INTEGER |
Primary key—The unique ID for a rule in a geodatabase and the foreign key to the ID field in the GDB_VALIDRULES table
NOT NULL |
EDGECLASSID |
INTEGER |
The object class ID of the edge feature class and the foreign key to the ID field in the GDB_GEOMNETWORKS table
NOT NULL |
EDGESUBTYPE |
INTEGER |
The subtype of the edge feature class
NOT NULL |
JUNCTIONCLASSID |
INTEGER |
The object class ID of the junction feature class and the foreign key to the ID field in the GDB_GEOMNETWORKS table
NOT NULL |
JUNCTIONSUBTYPE |
INTEGER |
The subtype of the junction feature class
NOT NULL |
EDGEMINCARD |
INTEGER |
The minimum edge cardinality (the minimum number of edges to which a junction can connect)
NOT NULL |
EDGEMAXCARD |
INTEGER |
The maximum edge cardinality (the maximum number of edges to which a junction can connect)
NOT NULL |
JUNCTIONMINCARD |
INTEGER |
The minimum junction cardinality (the minimum number of junctions to which an edge can connect)
NOT NULL |
JUNCTIONMAXCARD |
INTEGER |
The maximum junction cardinality (the maximum number of junctions to which an edge can connect)
NOT NULL |
ISDEFAULT |
INTEGER |
Will contain a value of 0 or 1 indicating if a junction is a default junction and has been created automatically |
Field name |
Field type |
Description |
OID |
INTEGER |
The unique ID of a weight in a geodatabase
NOT NULL |
NETWORKID |
INTEGER |
The unique ID for the geometric network in a geodatabase and the foreign key to the ID fields in the GDB_GEOMNETWORKS, GDB_NETWORKS, and GDB_EXTENSIONDATASETS tables
NOT NULL |
NAME |
VARCHAR(160) |
The name of the weight, which must be unique in each network
NOT NULL |
WEIGHTID |
INTEGER |
The unique ID of the weight in the geometric network
NOT NULL |
WEIGHTTYPE |
INTEGER |
A value indicating the type of network weight
NOT NULL |
BITGATESIZE |
INTEGER |
A value from 0 to 31 indicating the size of the BitGate weight
(NonBitGate weights have a value of 0.) |
ELEMENTTYPES |
INTEGER |
Denotes the type of network weight |
Field name |
Field type |
Description |
ID |
INTEGER |
The unique ID and primary key of the logical network in a geodatabase.
NOT NULL. |
DATABASENAME |
VARCHAR(32) |
Database in which the network is stored.
NOT NULL. |
OWNER |
VARCHAR(32) |
The name of the user who created the network.
NOT NULL. |
NAME |
VARCHAR(160) |
The name of the network.
NOT NULL. |
NETWORKTYPE |
INTEGER |
A value indicating the type of network.
All networks created using ArcGIS Desktop will have a value of 1 = esriNTUtilityNetwork.
NOT NULL. |
INDEXTYPE |
INTEGER |
Not currently implemented.
NOT NULL. |
NORMALIZED |
INTEGER |
A value of either 0 or 2, which indicates whether the network is narrow or wide.
Narrow networks contain feature classes with ObjectIDs less than 10,000; wide networks can contain feature classes with OBJECTIDs greater than 10,000.
NOT NULL. |
Field name |
Field type |
Description |
ID |
INTEGER |
Unique identifier for the object class
Primary key
NOT NULL |
DATABASENAME |
VARCHAR(32) |
Name of the database in which the object is stored
NOT NULL |
OWNER |
VARCHAR(32) |
User who owns the object class
NOT NULL |
NAME |
VARCHAR(160) |
Name of the object class
NOT NULL |
ALIASNAME |
VARCHAR(160) |
Alternative name of the object class |
MODELNAME |
VARCHAR(160) |
Alternate name of the object class; used to identify the type of entity without requiring a hard-coded name |
CLSID |
VARCHAR(38) |
GUID that uniquely identifies the type of object class
NOT NULL |
EXTCLSID |
VARCHAR(38) |
GUID that uniquely identifies the extension of an object class |
EXTPROPS |
BLOB |
Stores the properties of the associated class extension |
SUBTYPEFIELD |
VARCHAR(32) |
Name of the field in the object class for defining subtypes |
DATASETID |
INTEGER |
Foreign key to the ID field in the GDB_FEATUREDATASET table |
Field name |
Field type |
Description |
ID |
INTEGER |
Unique identifier of the relationship class.
Primary key.
NOT NULL. |
DATABASENAME |
VARCHAR(32) |
Name of the database in which the relationship class resides.
NOT NULL. |
OWNER |
VARCHAR(32) |
User who owns the relationship class.
NOT NULL. |
NAME |
VARCHAR(160) |
Name of the relationship class.
NOT NULL. |
ORIGINCLASSID |
INTEGER |
ID of the origin object class.
NOT NULL. |
DESTCLASSID |
INTEGER |
ID of the destination object class.
NOT NULL. |
FORWARDLABEL |
VARCHAR(255) |
Label that describes the relationship when navigating from origin class to destination class. |
BACKWARDLABEL |
VARCHAR(255) |
Label that describes the relationship when navigating from destination class to origin class. |
CARDINALITY |
INTEGER |
Code representing the type of cardinality of the relationship class.
1 = one to one
2 = one to many
3 = many to many
NOT NULL. |
NOTIFICATION |
INTEGER |
Code indicating the notification direction.
1 = none (no messages propagated)
2 = forward (origin to destination)
3 = backward
4 = both (forward and backward notification)
NOT NULL. |
ISCOMPOSITE |
INTEGER |
If a relationship class is composite, destination objects cannot exist independently of their related origin objects.
Possible values are
0 (is simple, not composite) or 1 (is composite).
NOT NULL. |
ISATTRIBUTED |
INTEGER |
Indicates whether or not this is an attributed relationship.
NOT NULL. |
ORIGINPRIMARYKEY |
VARCHAR(32) |
The name of the primary key field of the origin object class.
NOT NULL. |
DESTPRIMARYKEY |
VARCHAR(32) |
The name of the primary key field in the destination object class.
NOT NULL. |
ORIGINFOREIGNKEY |
VARCHAR(32) |
The name of the foreign key field of the origin object class.
NOT NULL. |
DESTFOREIGNKEY |
VARCHAR(32) |
The name of the foreign key field in the destination object class.
NOT NULL. |
DATASETID |
INTEGER |
Foreign key to the GDB_FEATUREDATASET table. |
Field name |
Field type |
Description |
ID |
INTEGER |
Unique identifier for row. |
REPLICAID |
INTEGER |
Foreign key to the ID field in the GDB_REPLICAS table. |
EVENT |
INTEGER |
Indicates if an import (1) or an export (2) has been logged. |
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. |
LOGDATE |
TIMESTAMP |
The date on which the event occurred. |
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. |
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. |
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. |
Field name |
Field type |
Description |
ID |
INTEGER |
Unique identifier for the replica (child) version
Primary key
NOT NULL |
beNAME |
VARCHAR(32) |
Name of the replica (child) version of the geodatabase
NOT NULL |
OWNER |
VARCHAR(32) |
User who owns the replica (child) version of the geodatabase
NOT NULL |
VERSION |
VARCHAR(32) |
Name of the replica version in the parent geodatabase
NOT NULL |
PARENTID |
INTEGER |
ID of the replica in the parent geodatabase
NOT NULL |
REPDATE |
TIMESTAMP |
Date and time the replica was created
NOT NULL |
DEFQUERY |
BLOB |
Contains the replica description, which describes datasets and filters that define the replica
NOT NULL |
REPGUID |
VARCHAR(36) |
The GUID value that uniquely identifies the replica across geodatabases
NOT NULL |
REPCINFO |
VARCHAR(1800) |
The connection information for the relative replicas geodatabase |
ROLE |
INTEGER |
Indicates if a replica has the role of parent or child
NOT NULL |
Field name |
Field type |
Description |
RULEID |
INTEGER |
Unique identifier of the topology rule; foreign key to the ID field in the GDB_VALIDRULES table
NOT NULL |
ORIGINCLASSID |
INTEGER |
Foreign key to CLASSID field in GDB_TOPOCLASSES table
NOT NULL |
ORIGINSUBTYPE |
INTEGER |
Foreign key to SUBTYPECODE field in GDB_SUBTYPES table
NOT NULL |
ALLORIGINSUBTYPES |
INTEGER |
Indicates if rule applies to all subtypes in the origin feature class
NOT NULL |
DESTCLASSID |
INTEGER |
Foreign key to CLASSID field in GDB_TOPOCLASSES table
NOT NULL |
DESTSUBTYPE |
INTEGER |
Foreign key to SUBTYPECODE field in GDB_SUBTYPES table
NOT NULL |
ALLDESTSUBTYPES |
INTEGER |
Indicates if rule applies to all subtypes in the destination feature class
NOT NULL |
TOPOLOGYRULETYPE |
INTEGER |
The type of topology rule
NOT NULL |
NAME |
VARCHAR(160) |
User-defined name associated with the topology rule |
RULEGUID |
VARCHAR(38) |
GUID that uniquely identifies the topology rule
NOT NULL |
Field name |
Field type |
Description |
SDE_ID |
INTEGER |
Process identification number of the process that has locked the layer; foreign key to the sde_id column in PROCESS_INFORMATION table
NOT NULL |
LAYER_ID |
INTEGER |
Foreign key to layer_id field in 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
NOT NULL |
LOCK_TYPE |
CHARACTER(1) |
The type of layer lock can either be
0 = A read lock on the entire layer
1 = A write lock on the entire layer
2 = A read lock on an area within the layer
3 = A write lock on an area within the layer
4 = A layer autolock
NOT NULL |
MINX |
INTEGER |
The minimum x-coordinate of the bounding box used to define the features within an area locked during an area lock |
MINY |
INTEGER |
The minimum y-coordinate of the bounding box used to define the features within an area locked during an area lock |
MAXX |
INTEGER |
The maximum x-coordinate of the bounding box used to define the features within an area locked during an area lock |
MAXY |
INTEGER |
The maximum y-coordinate of the bounding box used to define the features within an area locked during an area lock |
Feild Name |
Field type |
Description |
LAYER_ID |
INTEGER |
Unique identifier for the layer
Primary key
NOT NULL |
DESCRIPTION |
VARCHAR(65) |
The optional layer description
|
DATABASE_NAME |
VARCHAR(8) |
Name of the database in which the layer is stored |
OWNER |
VARCHAR(30) |
The user who created the layer
NOT NULL |
TABLE_NAME |
VARCHAR(128) |
Name of the business table of the layer
NOT NULL |
SPATIAL_COLUMN |
VARCHAR(128) |
Name of the spatial column in the layer |
EFLAGS |
INTEGER |
Stores the following layer properties:
- Layer stores single precision or double precision coordinates
- Layer stores 3D coordinates
- Layer stores measures
- Layer has autolocking enabled or disabled
- Layer is in load only io mode or normal io mode
- Layer stores annotation
- Layer stores CAD data
- Layer is a view of another layer
- Layer does not have a spatial index
- The DBMS data type in which the layer data is stored
- The sde types that the layer can accept, which can be such types as points, linestrings, polygons
|
LAYER_MASK |
INTEGER |
Stores additional internal properties about the layer |
GSIZE1 |
DOUBLE |
Size of first spatial grid |
GSIZE2 |
DOUBLE |
Size of second spatial grid |
GSIZE3 |
DOUBLE |
Size of third spatial grid |
MINX |
DOUBLE |
Minimum x-coordinate value of the layer |
MINY |
DOUBLE |
Minimum y-coordinate value of the layer |
MAXX |
DOUBLE |
Maximum x-coordinate value of the layer |
MAXY |
DOUBLE |
Maximum y-coordinate vlue of the layer |
MINZ |
DOUBLE |
Minimum z-coordinate value of the layer |
MAXZ |
DOUBLE |
Maximum z-coordinate value of the layer |
MINM |
DOUBLE |
Minimum measure value of the layer |
MAXM |
DOUBLE |
Maximum measure value of the layer |
CDATE |
INTEGER |
The layer creation date
NOT NULL |
LAYER_CONFIG |
VARCHAR(32) |
Configuration keyword with which the layer was created |
OPTIMAL_ARRAY_SIZE |
INTEGER |
Geometry array buffer size |
STATS_DATE |
INTEGER |
When 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
NOT NULL |
Field name |
Field type |
Description |
RECORD_ID |
INTEGER |
Unique identifier for the record
Primary key
NOT NULL |
OBJECT_NAME |
VARCHAR(160) |
The name of the locator to which the property belongs and foreign key to the name column in the LOCATORS table
NOT NULL |
OBJECT_DATABASE |
VARCHAR(32) |
The name of the database in which the locator is stored |
OBJECT_OWNER |
VARCHAR(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 |
VARCHAR(32) |
Always a value of SDE_internal for locator properties |
PROPERTY |
VARCHAR(32) |
The name of the locator property |
PROP_VALUE |
VARCHAR(255) |
The value of the locator property |
DESCRIPTION |
VARCHAR(65) |
Not used for locator properties |
CREATION_DATE |
TIMESTAMP |
Date and time the locator property was created
NOT NULL |
Field name |
Field type |
Description |
SDE_ID |
INTEGER |
Process identification number of the process that locked the geodatabase object; references sde_id column in PROCESS_INFORMATION table
NOT NULL |
OBJECT_ID |
INTEGER |
ID from the OBJECT_CLASSES table of the affected dataset
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 if the layer lock was set by the application
NOT NULL |
LOCK_TYPE |
CHARACTER(1) |
The type of object lock, which include
'S' for shared
'E' for exclusive
NOT NULL |
Field name |
Field type |
Description |
SDE_ID |
INTEGER |
Process identification number
NOT NULL |
APP_ID |
VARCHAR(32) |
The internal DB2 application ID
NOT NULL |
SERVER_ID |
INTEGER |
The operating system process ID of the server process
NOT NULL |
START_TIME |
TIMESTAMP |
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 |
VARCHAR(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 |
VARCHAR(32) |
The operating system that the client machine is running
NOT NULL |
NODENAME |
VARCHAR(255) |
The connected client machine name
NOT NULL |
XDR_NEEDED |
VARCHAR(1) |
Records whether or not client is using xdr to communicate with the gsrvr
T (true) or F (false)
NOT NULL |
Field name |
Field type |
Description |
RASTERCOLUMN_ID |
INTEGER |
The primary key of the raster column table
NOT NULL |
DESCRIPTION |
VARCHAR(65) |
The description of the raster table |
DATABASE_NAME |
VARCHAR(32) |
Name of the database in which the raster is stored
NOT NULL |
OWNER |
VARCHAR(32) |
The owner of the raster column's business table
NOT NULL |
TABLE_NAME |
VARCHAR(128) |
The business table name
NOT NULL |
RASTER_COLUMN |
VARCHAR(128) |
The raster column name
NOT NULL |
CDATE |
INTEGER |
The date the raster column was added to the business table
NOT NULL |
CONFIG_KEYWORD |
VARCHAR(32) |
The DBTUNE configuration keyword whose storage parameters determine 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, this value 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 SPATIAL_REFERENCES table |
Field name |
Field type |
Description |
COLUMN_ID |
INTEGER |
The XML column's identifier; value assigned by ArcSDE at the time the XML column is created
Primary key
NOT NULL |
REGISTRATION_ID |
INTEGER |
The identifier of the business table containing the XML column; a foreign key to the ArcSDE table registry
NOT NULL |
COLUMN_NAME |
VARCHAR(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 |
VARCHAR(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 uncompressed; by default, documents stored compressed (Compressed documents provide better performance.) |
Field name |
Field type |
Description |
INDEX_ID |
INTEGER |
The identifier of the XPath index associated with an 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 |
VARCHAR(896) |
An absolute XPath identifying an XML element or attribute that may occur in an XML document.
(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.
1 = The content of the tag will be indexed as text.
2 = The content will be indexed as a number.
NOT NULL. |
TAG_ALIAS |
INTEGER |
A number that may 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 |
VARCHAR(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.
0 = included
1 = excluded
NOT NULL. |
Field name |
Field type |
Description |
INDEX_ID |
INTEGER |
The identifier of the XPath index.
Primary key.
NOT NULL. |
INDEX_NAME |
VARCHAR(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 |
VARCHAR(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. |
INDEX_TYPE |
INTEGER |
A value indicating the type of XPath index.
1 = index type SE_XML_INDEX_TEMPLATE.
2 = index type SE_XML_INDEX_DEFINITION.
For XPath indexes associated with an ArcIMS Metadata Service, only the index type SE_XML_INDEX_DEFINITION is supported. |
DESCRIPTION |
VARCHAR(64) |
Text identifying the XPath index.
If an index definition file was used to create the index, the index's description may be specified at the top of the file. |
NOTE: This view is a Spatial Extender view and is not stored in the schema belonging to the ArcSDE administrator (the SDE user).
NOTE: This view is a Spatial Extender view and is not stored in the schema belonging to the ArcSDE administrator (the SDE user).
Field name |
Field type |
Description |
TABLE_SCHEMA |
VARCHAR(128) |
The owner of the geometry column's table. |
TABLE_NAME |
VARCHAR(128) |
Unqualified name of the table that contains the geometry column. |
COLUMN_NAME |
VARCHAR(128) |
Name of the geometry column.
The combination of TABLE_SCHEMA, TABLE_NAME, and COLUMN_NAME uniquely identifies the column.
NOT NULL. |
TYPE_SCHEMA |
VARCHAR(128) |
Name of the schema to which the declared data type of this spatial column belongs.
This name is obtained from the DB2 catalog.
NOT NULL. |
TYPE_NAME |
VARCHAR(128) |
Unqualified name of the declared data type of this spatial column. This name is obtained from the DB2 catalog.
NOT NULL. |
SRS_NAME |
VARCHAR(128) |
Name of the spatial reference system that is associated with this spatial column; if no spatial reference system is associated with the column, SRS_NAME is null.
A spatial reference system can be associated with a spatial column by using the command db2gse register_spatial_column with the appropriate parameters.
|
SRS_ID |
INTEGER |
Numeric identifier of the spatial reference system that is associated with this spatial column; if no spatial reference system is associated with the column, then SRS_ID is null. |
NOTE: This view is a Spatial Extender view and is not stored in the schema belonging to the ArcSDE administrator (the SDE user).
Field name |
Field type |
Description |
SR_NAME |
VARCHAR(128) |
Spatial reference name
NOT NULL |
SRID |
INTEGER |
Spatial reference ID
NOT NULL |
X_OFFSET |
DOUBLE |
Offset applied to x-coordinate values
NOT NULL |
X_SCALE |
DOUBLE |
Scale factor applied to x-coordinates after applying OFFSET
NOT NULL |
Y_OFFSET |
DOUBLE |
Offset applied to y-coordinate values
NOT NULL |
Y_SCALE |
DOUBLE |
Scale factor applied to y-coordinates after applying OFFSET
NOT NULL |
Z_OFFSET |
DOUBLE |
Offset applied to z-coordinate values
NOT NULL |
Z_SCALE |
DOUBLE |
Scale factor applied to z-coordinates after applying OFFSET
NOT NULL |
M_OFFSET |
DOUBLE |
Offset applied to measures
NOT NULL |
M_SCALE |
DOUBLE |
Scale factor applied to measures after applying OFFSET
NOT NULL |
MIN_X |
DOUBLE |
Minimum possible x-value for coordinates
NOT NULL |
MAX_X |
DOUBLE |
Maximum possible x-value for coordinates
NOT NULL |
MIN_Y |
DOUBLE |
Minimum possible y-value for coordinates
NOT NULL |
MAX_Y |
DOUBLE |
Maximum possible y-value for coordinates
NOT NULL |
MIN_Z |
DOUBLE |
Minimum possible z-value for coordinates
NOT NULL |
MAX_Z |
DOUBLE |
Maximum possible z-value for coordinates
NOT NULL |
MIN_M |
DOUBLE |
Minimum possible m-value for measures
NOT NULL |
MAX_M |
DOUBLE |
Maximum possible m-value for measures
NOT NULL |
COORDSYS_NAME |
VARCHAR(128) |
Name of the coordinate system for this spatial reference system
NOT NULL |
COORDSYS_TYPE |
VARCHAR(128) |
Type of coordinate system: PROJECTED, GEOGRAPHIC, or UNSPECIFIED
NOT NULL |
ORGANIZATION |
NVARCHAR2(128) |
Name of the organization that defined the coordinate system |
ORGANIZATION_COORDSYS_ID |
INTEGER |
Coordinate system ID defined by the organization |
DEFINITION |
VARCHAR(2048) |
Well-known text description of the coordinate system
NOT NULL |
DESCRIPTION |
VARCHAR(256) |
Description for the spatial reference system indicating its application |
Field name |
Field type |
Description |
REGISTRATION_ID |
INTEGER |
Unique identifier for the registration of the table
Primary key
NOT NULL |
DATABASE_NAME |
VARCHAR(32) |
Name of the database in which the table is stored
NOT NULL |
OWNER |
VARCHAR(32) |
User who created the table
NOT NULL |
TABLE_NAME |
VARCHAR(128) |
Name of the table
NOT NULL |
ROWID_COLUMN |
VARCHAR(32) |
Name of the ObjectID column in the table |
DESCRIPTION |
VARCHAR(65) |
The text description of the table
|
OBJECT_FLAGS |
INTEGER |
Stores the registration properties of the table, which include
- The table has a registered row ID.
- SDE controls the row ID.
- The table has a geometry column.
- The table is a multiversioned view.
- The table can be row locked.
- The table has a raster column.
- The table is a view of another table.
- The table has a geocoding locator column.
- Data definition language operations are restricted.
- Data manipulation language operations are restricted.
- The table is hidden.
- The table has single row IDs.
- The table has an XML column.
- The table has a layer that stores double coordinates.
- The interior states of this versioned table can be edited.
- This is a base save table.
- This table has trusted shapes.
- This is an archiving table.
- This table is in load only I/O mode.
- This is a history table.
NOT NULL |
REGISTRATION_DATE |
INTEGER |
The date the table was registered
NOT NULL |
CONFIG_KEYWORD |
VARCHAR(32) |
Configuration keyword with which the table was created
|
MINIMUM_ID |
INTEGER |
The minimum row_id value of the table
|
IMV_VIEW_NAME |
VARCHAR(32) |
The name of a multiversioned view of the given table
|
Field name |
Field type |
Description |
MAJOR |
INTEGER |
Number of the major release; for example, for ArcSDE 9.1, the major release number would be 9
NOT NULL |
MINOR |
INTEGER |
Number indicating the version of the major release; for example, for ArcSDE 9.1, the minor release number would be 1
NOT NULL |
BUGFIX |
INTEGER |
Number of the patch or service pack installed
NOT NULL |
DESCRIPTION |
VARCHAR(96) |
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 |
Field name |
Field type |
Description |
NAME |
VARCHAR(64) |
The unique name of the version
NOT NULL |
OWNER |
VARCHAR(32) |
The version owner
NOT NULL |
VERSION_ID |
INTEGER |
The unique ID 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 ID of the database state to which this version points
NOT NULL |
DESCRIPTION |
VARCHAR(65) |
An optional text description of the version |
PARENT_NAME |
VARCHAR(64) |
The name of this version's parent version |
PARENT_OWNER |
VARCHAR(32) |
The name of the owner of the parent version |
PARENT_VERSION_ID |
INTEGER |
The ID of the version that is the parent of this version |
CREATION_TIME |
TIMESTAMP |
The date/time that this version was created
NOT NULL |