3.1.4.2.2.1.3.58.1 Columns

The DISCOVER_STORAGE_TABLES rowset contains the following columns.

Name

Type

Restriction

Description

DATABASE_NAME

xsd:string

Yes<333>

The name of the database.

CUBE_NAME

xsd:string

Yes<334>

The name of the cube.

MEASURE_GROUP_NAME

xsd:string

Yes<335>

The name of the measure group.

PARTITION_NAME

xsd:string

Yes<336>

The name of the partition.

DIMENSION_NAME

xsd:string

The name of the dimension.

TABLE_ID

xsd:string

The ID of the table.

TABLE_PARTITIONS_COUNT

xsd:long

The table partition count.

HINT_TABLE_TYPE

xsd:string

The hint of the table type.

ROWS_COUNT

xsd:long

The row count.

RIVIOLATION_COUNT

xsd:long

The number of relationships that have RI violations.

The rowset is not sorted.

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:complexType name="row">
         <xsd:sequence>
           <xsd:element sql:field="DATABASE_NAME" name="DATABASE_NAME" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="CUBE_NAME" name="CUBE_NAME" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="MEASURE_GROUP_NAME" name="MEASURE_GROUP_NAME" 
                        type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="PARTITION_NAME" name="PARTITION_NAME" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="DIMENSION_NAME" name="DIMENSION_NAME" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="TABLE_ID" name="TABLE_ID" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="TABLE_PARTITIONS_COUNT" name="TABLE_PARTITIONS_COUNT" 
                        type="xsd:long" minOccurs="0" />
           <xsd:element sql:field="HINT_TABLE_TYPE" name="HINT_TABLE_TYPE" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="ROWS_COUNT" name="ROWS_COUNT" type="xsd:long" 
                        minOccurs="0" />
           <xsd:element sql:field="RIVIOLATION_COUNT" name="RIVIOLATION_COUNT" type="xsd:long" 
                        minOccurs="0" />
         </xsd:sequence>
       </xsd:complexType>
  • Last updated on