2.5.3 Contents of the .tbl.xml Files

Each file that contains metadata for a table (.tbl.xml file) contains an XMSimpleTable object. These table metadata files differ according to which columns exist in the Columns collection of the XMSimpleTable object. The following table specifies which columns exist for each type of table metadata file.

Type of table metadata file

Example file name

Columns collection content

Column hierarchy file

H$Table-Diet$wt.0.tbl.xml

One column collection item for each of the system-generated hierarchy indexes: ID_TO_POS and POS_TO_ID.

User hierarchy metadata file

U$Hierarchy$1.0.tbl.xml

One column collection item for each of the system-generated user hierarchy columns: CHILD_COUNT, FIRST_CHILD_POS, and MULTI_LEVEL_ID, PARENT_POS.

Table relationship file

R$Table-Diet$ec91bf00-f577-4c86-b7f8-8c5dcd44a2ac.64.tbl.xml

One column collection item for the system-generated relationship file column: INDEX.

Table metadata file

Table-Diet.31.tbl.xml

One column collection item for each column in the source data table.