Data Mining Schema Rowsets
APPLIES TO:SQL Server Analysis ServicesAzure Analysis Services
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
|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.