Knowledge Base - Technical Articles
FAQ: How is metadata stored for ArcSDE geodatabases?
|Software:||ArcGIS - ArcInfo 8.0.1, 8.0.2, 8.1 ArcSDE 8.0.1, 8.0.2, 8.1|
How is metadata stored for ArcSDE geodatabases?
The metadata for an ArcSDE feature class is stored in a table called SDE.GDB_USERMETADATA. The metadata for feature classes are identified in this table by the owner and table name (and possibly database name) of the base table. In Oracle, SDE.GDB_USERMETADATA is described like this:
SQL> describe sde.gdb_usermetadata
Name Null? Type
------------------------------- -------- ----
ID NOT NULL NUMBER(38)
OWNER NOT NULL VARCHAR2(32)
NAME NOT NULL VARCHAR2(160)
DATASETTYPE NOT NULL NUMBER(38)
XML NOT NULL LONG RAW
- Delete metadata created with ArcCatalog
There is no way to delete metadata for an item within ArcCatalog. However, metadata for file-based items can be deleted with Windows explorer. Metadata describing items in a geodatabase is stored as a blob of XML within the geodatabase in the admi...
Last Modified: 6/6/2001