XML for Analysis - Microsoft SQL Server 2008 Analysis Services - page 582

</xsd:restriction>
</xsd:simpleType>
<xsd:sequence>
The name and type attributes return the name of the column and the type of data it
contains. The returned rowset could contain two or more columns with the same name.
However, XML cannot have two elements with the same name. To enable the client appli-
cation to distinguish between columns with the same name, sql:field contains attributes
with unique names, and name contains a name that can be shown the client. The follow-
ing shows the use of these attributes to distinguish columns in our example:
<xsd:element sql:field = “CATALOG_NAME” name = “CATALOG_NAME” type =
➥ “xsd:string”/>
<xsd:element sql:field = “SCHEMA_NAME” name = “SCHEMA_NAME” type =
➥ “xsd:string” minOccurs = “0”/>
<xsd:element sql:field = “CUBE_NAME” name = “CUBE_NAME” type =
➥ “xsd:string” minOccurs = “0”/>
<xsd:element sql:field = “CUBE_TYPE” name = “CUBE_TYPE” type =
➥ “xsd:string” minOccurs = “0”/>
<xsd:element sql:field = “CUBE_GUID” name = “CUBE_GUID” type = “uuid”
➥ minOccurs = “0”/>
<xsd:element sql:field = “CREATED_ON” name = “CREATED_ON” type =
➥ “xsd:dateTime” minOccurs = “0”/>
<xsd:element sql:field = “LAST_SCHEMA_UPDATE” name = “LAST_SCHEMA_UPDATE”
➥ type = “xsd:dateTime” minOccurs = “0”/>
<xsd:element sql:field = “SCHEMA_UPDATED_BY” name = “SCHEMA_UPDATED_BY”
➥ type = “xsd:string” minOccurs = “0”/>
<xsd:element sql:field = “LAST_DATA_UPDATE” name = “LAST_DATA_UPDATE”
➥ type = “xsd:dateTime” minOccurs = “0”/>
<xsd:element sql:field = “DATA_UPDATED_BY” name = “DATA_UPDATED_BY” type
➥ = “xsd:string” minOccurs = “0”/>
<xsd:element sql:field = “DESCRIPTION” name = “DESCRIPTION” type =
➥ “xsd:string” minOccurs = “0”/>
<xsd:element sql:field = “IS_DRILLTHROUGH_ENABLED” name =
➥ “IS_DRILLTHROUGH_ENABLED” type = “xsd:boolean” minOccurs = “0”/>
<xsd:element sql:field = “IS_LINKABLE” name = “IS_LINKABLE” type =
➥ “xsd:boolean” minOccurs = “0”/>
<xsd:element sql:field = “IS_WRITE_ENABLED” name = “IS_WRITE_ENABLED”
➥ type = “xsd:boolean” minOccurs = “0”/>
<xsd:element sql:field = “IS_SQL_ENABLED” name = “IS_SQL_ENABLED” type =
➥ “xsd:boolean” minOccurs = “0”/>
<xsd:element sql:field = “CUBE_CAPTION” name = “CUBE_CAPTION” type =
➥ “xsd:string” minOccurs = “0”/>
<xsd:element sql:field=”BASE_CUBE_NAME” name=”BASE_CUBE_NAME” type=”xsd:string”
➥ minOccurs=”0” />