Home    |    Concepts   |   API   |   Samples
Concepts > XML > Database Schema
SDE_XML_INDEXES Table

This table occurs once in each ArcSDE database. It contains one row for each XML column that has an XPath index.

Name Data Null? Description
INDEX_ID INT32 NOT NULL The identifier of the XPath index

The table?s primary key, also used to reference SE_XML_INDEX_TAGS table

INDEX_NAME STRING NOT NULL The name of the XPath index
OWNER STRING NOT NULL 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 INT32 NOT NULL A value indicating the type of XPath index

With ArcSDE 9.1, the value will be 2 for the index type SE_XML_INDEX_DEFINITION and 1 for the index type SE_XML_INDEX_TEMPLATE

For XPath indexes associated with an ArcIMS Metadata Service, only the index type SE_XML_INDEX_DEFINITION is supported.

DESCRIPTION STRING NULL 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

feedback | privacy | legal