This topic has not yet been rated - Rate this topic

3.1.4.2.2.1.3.24.1 Columns

SQL Server 2008 R2

The DMSCHEMA_MINING_MODEL_CONTENT_PMML rowset contains the following columns.

Name

Type

Restriction

Description

MODEL_CATALOG

xsd:string

Yes

The catalog name that is populated with the name of the database of which the model is a member.

MODEL_SCHEMA

xsd:string

Yes

The unqualified schema name.<214>

MODEL_NAME

xsd:string

Yes

The model name. This column cannot contain NULL.

MODEL_TYPE

xsd:string

Yes<215>

The model type. It is a server-specific string. It can be NULL.

MODEL_GUID

uuid

The GUID that identifies the model. Servers that do not use GUIDs to identify tables return NULL.

MODEL_PMML

xsd:string

An XML representation of the model's content in PMML format.

SIZE

xsd:unsignedInt

The number of bytes in the XML string.

LOCATION

xsd:string

The location of the XML file. It is NULL if no location is available.

This 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: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="xmlDocument">
        <xsd:sequence>
          <xsd:any />
        </xsd:sequence>
      </xsd:complexType>
      <xsd:complexType name="row">
        <xsd:sequence>
          <xsd:element sql:field="MODEL_CATALOG" name="MODEL_CATALOG" type="xsd:string" minOccurs="0" />
          <xsd:element sql:field="MODEL_SCHEMA" name="MODEL_SCHEMA" type="xsd:string" minOccurs="0" />
          <xsd:element sql:field="MODEL_NAME" name="MODEL_NAME" type="xsd:string" />
          <xsd:element sql:field="MODEL_TYPE" name="MODEL_TYPE" type="xsd:string" minOccurs="0" />
          <xsd:element sql:field="MODEL_GUID" name="MODEL_GUID" type="uuid" minOccurs="0" />
          <xsd:element sql:field="MODEL_PMML" name="MODEL_PMML" type="xmlDocument" minOccurs="0" />
          <xsd:element sql:field="SIZE" name="SIZE" type="xsd:unsignedInt" minOccurs="0" />
          <xsd:element sql:field="LOCATION" name="LOCATION" type="xsd:string" minOccurs="0" />
        </xsd:sequence>
      </xsd:complexType>
Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.