Data Mining Schema Rowsets

A server that is running Microsoft SQL Server Analysis Services supports the following data mining schema rowsets. To check whether a particular XML/A provider supports a specific rowset, use the DISCOVER_ENUMERATORS rowset with the Discover method.

In SQL Server 2017, the data mining schema rowsets are exposed as tables in the Transact-SQL language, in the $SYSTEM schema. For example, the following query on an Analysis Services instance returns a list of the schemas that are available on the current instance.

SELECT * FROM [$system].[DBSCHEMA_TABLES]  

In This Section

Schema Rowset Description
DMSCHEMA_MINING_COLUMNS Rowset Describes the individual columns of all defined data mining models that are deployed on the server.
DMSCHEMA_MINING_FUNCTIONS Rowset Describes the prediction functions and mining functions that can be used with each data mining algorithm that is installed on the server.
DMSCHEMA_MINING_MODEL_CONTENT Rowset Allows the client application to browse the content of a trained data mining model.
DMSCHEMA_MINING_MODEL_CONTENT_PMML Rowset Returns the XML (PMML 2.1) representation of the mining model content.
DMSCHEMA_MINING_MODEL_XML Rowset Returns the XML (PMML 2.1) structure of the mining model. This is the same schema as DMSCHEMA_MINING_MODEL_PMML, which is preserved for backward compatibility.
DMSCHEMA_MINING_MODELS Rowset Enumerates the data mining models that are deployed on the server.
DMSCHEMA_MINING_SERVICE_PARAMETERS Rowset Provides a list of parameters that can be used to configure the behavior of each data mining algorithm that is installed on the server.
DMSCHEMA_MINING_SERVICES Rowset Provides a description of each data mining algorithm that is available on the server.
DMSCHEMA_MINING_STRUCTURE_COLUMNS Rowset Describes the individual columns of all mining structures that are deployed on the server.
DMSCHEMA_MINING_STRUCTURES Rowset Enumerates information on mining structures.

All the schema rowsets listed here are supported by the server that is running SQL Server Analysis Services.

See Also

Analysis Services Schema Rowsets
Data Mining Schema Rowsets (SSAs)