DMSCHEMA_MINING_COLUMNS Rowset

 

Applies To: SQL Server 2016 Preview

Describes the individual columns of all data mining models in Microsoft SQL Server Analysis Services. This rowset is restricted to the current catalog.

The DMSCHEMA_MINING_COLUMNS rowset contains the following columns.

Column nameType indicatorDescription
MODEL_CATALOGDBTYPE_WSTRThe catalog name. Populated with the name of the database of which the model is a member.
MODEL_SCHEMADBTYPE_WSTRThe unqualified schema name. This column is not supported by Microsoft SQL Server Analysis Services; it always contains NULL.
MODEL_NAMEDBTYPE_WSTRThe mining model name. This column contains the name of the mining model with which a column is associated, and it is never empty.
COLUMN_NAMEDBTYPE_WSTRThe name of the column.
COLUMN_GUIDDBTYPE_GUIDThe column GUID. This column is not supported by Analysis Services; it always contains NULL.
COLUMN_PROPIDDBTYPE_UI4The column property ID. This column is not supported by Analysis Services; it always contains NULL.
ORDINAL_POSITIONDBTYPE_UI4The ordinal position of the column. Columns are numbered starting from 1. This column contains NULL if there is no stable ordinal value for the column.
COLUMN_HAS_DEFAULTDBTYPE_BOOLA Boolean that indicates whether the column has a default value.

 TRUE if the column has a default value, otherwise FALSE.
COLUMN_DEFAULTDBTYPE_WSTRThe default value of the column.

If the default value is the NULL value, COLUMN_HASDEFAULT contains TRUE, and this column contains NULL.
COLUMN_FLAGSDBTYPE_UI4A bitmask that describes characteristics of the column. The DBCOLUMNFLAGS enumerated type specifies the bits in the bitmask. This column is never empty.
IS_NULLABLEDBTYPE_BOOLA Boolean that indicates whether the column is nullable.

 FALSE if the column is known not to be nullable; otherwise, TRUE.
DATA_TYPEDBTYPE_UI2The indicator of the column's data type. The following list shows examples of the types of indicator returned:

"TABLE" would return DBTYPE_HCHAPTER.

"TEXT" would return DBTYPE_WCHAR.

"LONG" would return DBTYPE_I8.

"DOUBLE" would return DBTYPE_R8.

"DATE" would return DBTYPE_DATE.
TYPE_GUIDDBTYPE_GUIDThe GUID of the column's data type. This column is not supported by Analysis Services; it always contains VT_NULL.
CHARACTER_MAXIMUM_LENGTHDBTYPE_UI4The maximum possible length of a value in the column. For character, binary, or bit columns, this is one of the following:

The maximum length of the column in characters, bytes, or bits, respective to the column type, if a length is defined. For example, a CHAR(5) column in an SQL table has a maximum length of 5.

The maximum length of the data type in characters, bytes, or bits, respective to the column type, if the column does not have a defined length.

Zero (0) if neither the column nor the data type has a defined maximum length.

 NULL for all other types of columns
CHARACTER_OCTET_LENGTHDBTYPE_UI4The maximum length in octets (bytes) of the column, if the type of the column is character or binary. A value of zero (0) means the column has no maximum length. This column contains NULL for all other types of columns.
NUMERIC_PRECISIONDBTYPE_UI2The maximum precision of the column if the column's data type is of a numeric data type other than VARNUMERIC.

 NULL if the column's data type is not numeric or is VARNUMERIC.

The precision of columns with a data type of DBTYPE_DECIMAL or DBTYPE_NUMERIC depends on the column definition.
NUMERIC_SCALEDBTYPE_I2The number of digits to the right of the decimal point if the column's type indicator is DBTYPE_DECIMAL, DBTYPE_NUMERIC, or DBTYPE_VARNUMERIC. Otherwise, this column contains VT_NULL.
DATETIME_PRECISIONDBTYPE_UI4The date/time precision (number of digits in the fractional seconds portion) of the column if the column data type is a DateTime or interval type; otherwise, NULL.
CHARACTER_SET_CATALOGDBTYPE_WSTRThe catalog name in which the character set is defined. This column is not supported by Analysis Services; it always contains NULL.
CHARACTER_SET_SCHEMADBTYPE_WSTRAn unqualified schema name in which the character set is defined. This column is not supported by Analysis Services; it always contains NULL.
CHARACTER_SET_NAMEDBTYPE_WSTRThe character set name. This column is not supported by Analysis Services; it always contains NULL.
COLLATION_CATALOGDBTYPE_WSTRThe catalog name in which the collation is defined. This column is not supported by Analysis Services; it always contains NULL.
COLLATION_SCHEMADBTYPE_WSTRAn unqualified schema name in which the collation is defined. This column is not supported by Analysis Services; it always contains NULL.
COLLATION_NAMEDBTYPE_WSTRThe collation name. This column is not supported by Analysis Services; it always contains NULL.
DOMAIN_CATALOGDBTYPE_WSTRThe catalog name in which the domain is defined. This column is not supported by Analysis Services; it always contains NULL.
DOMAIN_SCHEMADBTYPE_WSTRThe unqualified schema name in which the domain is defined. This column is not supported by Analysis Services; it always contains NULL.
DOMAIN_NAMEDBTYPE_WSTRThe domain name. This column is not supported by Analysis Services; it always contains NULL.
DESCRIPTIONDBTYPE_WSTRA user-friendly description of the column This column is not supported by Analysis Services; it always contains NULL.
DISTRIBUTION_FLAGDBTYPE_WSTRA description of the statistical distribution of the column. This column contains one of the following:

"NORMAL"

"LOG_NORMAL"

"UNIFORM"
CONTENT_TYPEDBTYPE_WSTRA description of the content of the column. This column contains one of the following:

"KEY"

"DISCRETE"

"CONTINUOUS"

"DISCRETIZED([arguments])"

"ORDERED"

"KEY TIME"

"CYCLICAL"

"PROBABILITY"

"VARIANCE"

"STDEV"

"SUPPORT"

"PROBABILITY_VARIANCE"

"PROBABILITY_STDEV"

 "KEY SEQUENCE"
MODELING_FLAGDBTYPE_WSTRA comma-delimited list of flags. The defined flags are:

"MODEL_EXISTENCE_ONLY"

"REGRESSOR"

Algorithm-specific modeling flags can also be contained in this column.
IS_RELATED_TO_KEYDBTYPE_BOOLA Boolean that indicates whether the column is related to the key.

 TRUE if this column is related to the key. If the key is a single column, the RELATED_ATTRIBUTE field can optionally contain its column name.
RELATED_ATTRIBUTEDBTYPE_WSTRThe name of the target column to which the current column either relates or is a special property.
IS_INPUTDBTYPE_BOOLA Boolean that indicates whether the column is an input column.

 VARIANT_TRUE if this is an input column.
IS_PREDICTABLEDBTYPE_BOOLA Boolean that indicates whether the column is predictable.

 TRUE if the column is predictable.
CONTAINING_COLUMNDBTYPE_WSTRThe name of the TABLE column that contains this column. This column contains NULL if the column is not contained in another column.
PREDICTION_SCALAR_FUNCTIONSDBTYPE_WSTRA comma-delimited list of scalar functions that can be performed on the column.
PREDICTION_TABLE_FUNCTIONSDBTYPE_WSTRA comma-delimited list of functions that can be applied to the column. The functions should return a table. The list has the following format:

 <function name>(<column1> [, <column2>], ...)

The format allows the client application to determine the signature (list of parameters) for the respective function.
IS_POPULATEDDBTYPE_BOOLA Boolean that indicates whether the column has been trained with a set of possible values.

 TRUE if the column has been trained with a set of possible values.

Contains FALSE if the column is not populated.
PREDICTION_SCOREDBTYPE_R8The score of the model on predicting the column. Score is used to measure the accuracy of a model.
SOURCE_COLUMNDBTYPE_WSTRThe name of the source mining structure column for the current mining column.

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

Column nameType indicatorRestriction State
MODEL_CATALOGDBTYPE_WSTROptional.
MODEL_SCHEMADBTYPE_WSTROptional.
MODEL_NAMEDBTYPE_WSTROptional.
COLUMN_NAMEDBTYPE_WSTROptional.

Data Mining Schema Rowsets

Community Additions

ADD
Show: