Export (0) Print
Expand All

DMSCHEMA_MINING_MODEL_CONTENT_PMML Rowset

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Returns the XML structure of the mining model. The format of the XML string follows the Predictive Model Markup Language (PMML 2.1) standard.

The DMSCHEMA_MINING_MODEL_CONTENT_PMML rowset contains the following columns.

Column name

Type indicator

Length

Description

MODEL_CATALOG

DBTYPE_WSTR

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

MODEL_SCHEMA

DBTYPE_WSTR

The unqualified schema name. This column is not supported by Microsoft SQL Server Analysis Services; it always contains NULL.

MODEL_NAME

DBTYPE_WSTR

The model name. This column cannot contain NULL.

MODEL_TYPE

DBTYPE_WSTR

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

MODEL_GUID

DBTYPE_GUID

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

MODEL_PMML

DBTYPE_WSTR

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

SIZE

DBTYPE_UI4

The number of bytes in the XML string.

LOCATION

DBTYPE_WSTR

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

This schema rowset is not sorted.

The DMSCHEMA_MINING_MODEL_CONTENT_PMML rowset can be restricted on the columns listed in the following table.

Column name

Type indicator

Restriction State

MODEL_CATALOG

DBTYPE_WSTR

Optional.

MODEL_SCHEMA

DBTYPE_WSTR

Optional.

MODEL_NAME

DBTYPE_WSTR

Optional.

MODEL_TYPE

DBTYPE_WSTR

Optional.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft