3.1.4.2.2.1.3.2.1 Columns

The DBSCHEMA_TABLES rowset contains the following columns.

Name

Type

Restriction

Description

TABLE_CATALOG

xsd:string

Yes

The name of the database.

TABLE_SCHEMA

xsd:string

Yes

The name of the schema.

TABLE_NAME

xsd:string

Yes

The name of the table.

TABLE_TYPE<206>

xsd:string

Yes

The type of table:

  • TABLE for measure group.

  • SYSTEM TABLE for dimension.

  • SCHEMA for schema rowset table.

TABLE_GUID

uuid

The GUID of the table.

DESCRIPTION

xsd:string

A description of the object.

TABLE_PROPID

xsd:unsignedInt

The ID of the table.

DATE_CREATED

xsd:dateTime

The date the table was created.

DATE_MODIFIED

xsd:dateTime

The date the table was last modified.

TABLE_OLAP_TYPE<207>

xsd:string

Yes

The OLAP type of the object:

  • CUBE_DIMENSION indicates that the object is a cube dimension.

  • MEASURE_GROUP indicates that the object is a measure group.

  • SCHEMA indicates that the object is a schema rowset table.

The response has the following definition.

      <xsd:element name="root">
         <xsd:complexType>
           <xsd:sequence minOccurs="0" maxOccurs="unbounded">
             <xsd:element name="row" type="row" />
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:simpleType name="uuid">
         <xsd:restriction base="xsd:string">
           <xsd:pattern value="[0-9a-zA-Z]{8}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{12}" />
         </xsd:restriction>
       </xsd:simpleType>
       <xsd:complexType name="row">
         <xsd:sequence>
           <xsd:element sql:field="TABLE_CATALOG" name="TABLE_CATALOG" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="TABLE_SCHEMA" name="TABLE_SCHEMA" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="TABLE_NAME" name="TABLE_NAME" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="TABLE_TYPE" name="TABLE_TYPE" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="TABLE_GUID" name="TABLE_GUID" type="uuid" minOccurs="0" />
           <xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="TABLE_PROPID" name="TABLE_PROPID" type="xsd:unsignedInt" 
                        minOccurs="0" />
           <xsd:element sql:field="DATE_CREATED" name="DATE_CREATED" type="xsd:dateTime" 
                        minOccurs="0" />
           <xsd:element sql:field="DATE_MODIFIED" name="DATE_MODIFIED" type="xsd:dateTime" 
                        minOccurs="0" />
           <xsd:element sql:field="TABLE_OLAP_TYPE" name="TABLE_OLAP_TYPE" type="xsd:string" 
                        minOccurs="0" />
         </xsd:sequence>
       </xsd:complexType>
  • Last updated on