Applies To: SQL Server 2016 Preview
Enumerates the data mining models in the current catalog. The DMSCHEMA_MINING_MODELS rowset includes information such as model names, processing date, and the mining algorithm associated with each mining model.
. The DMSCHEMA_MINING_MODELS schema rowset is very similar to the DBSCHEMA_TABLES schema rowset and can be used the same way.
The DMSCHEMA_MINING_MODELS rowset contains the following columns.
|Column name||Type indicator||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 Analysis Services; 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 enumeration that identifies the type of data mining algorithm that is used by the model. This type can be one of the following values:|
|SERVICE_NAME||DBTYPE_WSTR||The provider-specific name for the data mining algorithm that is used by the model.|
|CREATION_STATEMENT||DBTYPE_WSTR||The statement that was used to create the mining model.|
|PREDICTION_ENTITY||DBTYPE_WSTR||A comma-delimited list indicating which mining columns can be predicted.|
|IS_POPULATED||DBTYPE_BOOL||A Boolean flag that indicates whether the model is populated.|
TRUE if the model is populated; otherwise, FALSE.
|MINING_PARAMETERS||DBTYPE_WSTR||A comma-separated list of the parameters that were used when the model was created.|
|MINING_STRUCTURE||DBTYPE_WSTR||The ID of 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 flag that indicates whether the model supports drillthrough.|
|FILTER||DBTYPE_WSTR||The filter expression that is associated with the mining model.|
NULL or empty string indicates that no filter is applied.
|TRAINING_SET_SIZE||DBTYPE_UIS||The number of cases that are contained in the mining model training set after the structure has been processed and after any filters have been applied to the model.|
The DMSCHEMA_MINING_MODELS rowset can be restricted on the columns in the following table.
|Column name||Type indicator||Restriction State|
For examples of how to query this rowset, see Query the Parameters Used to Create a Mining Model.