DMSCHEMA_MINING_MODELS Rowset

Enumerates the data mining models in the current catalog. The DMSCHEMA_MINING_MODELS schema rowset is quite similar to the DBSCHEMA_TABLES schema rowset and can be used the same way. Use the DMSCHEMA_MINING_MODELS rowset to obtain information about the mining models contained within a database. The DMSCHEMA_MINING_MODELS rowset can include information such as the names, types, and mining algorithms associated with each mining model.

Rowset Columns

The DMSCHEMA_MINING_MODELS rowset contains the following columns.

Column name	Type indicator	Length	Description
MODEL_CATALOG	DBTYPE_WSTR		The catalog name. 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 2005 Analysis Services (SSAS); it always contains NULL.
MODEL_NAME	DBTYPE_WSTR		The mining model name. This column contains the name of the mining model, and it is never empty.
MODEL_TYPE	DBTYPE_WSTR		The model type.
MODEL_GUID	DBTYPE_GUID		The GUID of the model.
DESCRIPTION	DBTYPE_WSTR		A user-friendly description of the model.
MODEL_PROPID	DBTYPE_UI4		The property ID of the model. This column is not supported by Analysis Services; it always contains NULL.
DATE_CREATED	DBTYPE_DBTIMESTAMP		The date on which the model was created.
DATE_MODIFIED	DBTYPE_DBTIMESTAMP		The date on which the model definition was last modified.
SERVICE_TYPE_ID	DBTYPE_UI4		An enumerated type that identifies the data mining algorithm used by the model. This enumerated type may be one of the following values: DM_SERVICETYPE_CLASSIFICATION DM_SERVICETYPE_SEGMENTATION
SERVICE_NAME	DBTYPE_WSTR		A string that contains the provider-specific name for the data mining algorithm used by the model.
CREATION_STATEMENT	DBTYPE_WSTR		A string that contains the statement that was used to create the mining model.
PREDICTION_ENTITY	DBTYPE_WSTR		A string that contains a comma-delimited list indicating which mining columns can be predicted.
IS_POPULATED	DBTYPE_BOOL		A Boolean that indicates whether the model is populated. TRUE if the model is populated. Otherwise it contains FALSE.
MINING_PARAMETERS	DBTYPE_WSTR		The parameter settings with which the model was created.
MINING_STRUCTURE	DBTYPE_WSTR		The mining structure on which the model is based.
LAST_PROCESSED	DBTYPE_DBTIMESTAMP		The date the model was last processed.
MSOLAP_IS_DRILLTHROUGH_ENABLED	DBTYPE_BOOL		A Boolean that indicates whether the model supports drill-through.

Restriction Columns

The DMSCHEMA_MINING_MODELS rowset can be restricted on the columns 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.
SERVICE_NAME	DBTYPE_WSTR	Optional.
SERVICE_TYPE_ID	DBTYPE_UI4	Optional.
MINING_STRUCTURE	DBTYPE_WSTR	Optional.

See Also

Reference

Data Mining Schema Rowsets

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release	History
14 April 2006	Changed content: Updated technical information in many of the column descriptions.