Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

DMSCHEMA_MINING_MODEL_CONTENT_PMML Rowset

 

Applies To: SQL Server 2016 Preview

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.

Community Additions

ADD
Show:
© 2015 Microsoft