DMSCHEMA_MINING_SERVICE_PARAMETERS Rowset

 

Applies To: SQL Server 2016 Preview

Describes the parameters for the algorithms on the server.

The DMSCHEMA_MINING_SERVICE_PARAMETERS rowset contains the following columns.

Column nameType indicatorDescription
SERVICE_NAMEDBTYPE_WSTRThe name of the algorithm.
PARAMETER_NAMEDBTYPE_WSTRThe name of the parameter.
PARAMETER_TYPEDBTYPE_WSTRThe type of the parameter.
IS_REQUIREDDBTYPE_BOOLA Boolean that returns TRUE if the parameter is required.
PARAMETER_FLAGSDBTYPE_UI4A bitmask that describes the characteristics of the parameter:

 DM_PARAMETER_TRAINING (0x0000001) indicates the parameter is used for training

 DM_PARAMETER_PREDICTION (0x00000002) indicates the parameter is used for prediction

 DM_PARAMETER_CONTENT (0x00000003) indicates the parameter is used for content restriction
DESCRIPTIONDBTYPE_WSTRA user-friendly description of the parameter.
DEFAULT_VALUEDBTYPE_WSTRThe default value of the parameter. Returns NULL if the default value is not a simple data type.
VALUE_ENUMERATIONDBTYPE_WSTRAn enumerator of possible values for the parameter.
HELP_FILEDBTYPE_WSTRThe name of the file that contains this parameter's documentation.
HELP_CONTEXTDBTYPE_I4The Help context ID for this function.

The DMSCHEMA_MINING_SERVICE_PARAMETERS rowset can be restricted on the columns listed in the following table.

Column nameType indicatorRestriction State
SERVICE_NAMEDBTYPE_WSTROptional.
PARAMETER_NAMEDBTYPE_WSTROptional.

Data Mining Schema Rowsets

Community Additions

ADD
Show: