DMSCHEMA_MINING_STRUCTURES Rowset

 

Applies To: SQL Server 2016 Preview

Enumerates information about the mining structures in the current catalog.

The DMSCHEMA_MINING_STRUCTURES rowset contains the following columns.

Column nameType indicatorLengthDescription
STRUCTURE_CATALOGDBTYPE_WSTRThe catalog name.
STRUCTURE_SCHEMADBTYPE_WSTRThe unqualified schema name. NULL if schemas are not supported by the provider.
STRUCTURE_NAMEDBTYPE_WSTRThe structure name. This column cannot contain NULL.
STRUCTURE_GUIDDBTYPE_GUIDA GUID that uniquely identifies the structure. NULL if not supported by the provider.
DESCRIPTIONDBTYPE_WSTRA concise description of the structure. NULL if no description is associated with the structure.
STRUCTURE_PROPIDDBTYPE_UI4The property ID of the structure. NULL if not supported by the provider.
DATE_CREATEDDBTYPE_DBTIMESTAMPThe date when the structure was created. NULL if not available from the provider.
DATE_MODIFIEDDBTYPE_DBTIMESTAMPThe date when the structure was last modified. NULL if not available from the provider.
CREATION_STATEMENTDBTYPE_WSTR(Optional) The statement that was used to create the original data mining model.
IS_POPULATEDDBTYPE_BOOLA Boolean that indicates whether the structure is populated.

 VARIANT_TRUE if the structure is populated; VARIANT_FALSE otherwise.
LAST_PROCESSEDDBTYPE_DBTIMESTAMPThe date when the structure was last processed. NULL if not available from the provider.
HOLDOUT_MAXPERCENTDBTYPE_ UI1User-specified value that indicates the maximum percentage of the input cases held out as the test set.

0 or NULL indicates no limit.
HOLDOUT_MAXCASESDBTYPE_UI8User-specified value that indicates the maximum number of the input cases held out as the test set.

0 or NULL indicates no limit.
HOLDOUT_SEEDDBTYPE_UI8User-specified value that is used as the seed for repeatable partitioning.

0 indicates that a hash of the mining structure ID is used as the seed.
HOLDOUT_ACTUAL_SIZEDBTYPE_UI8If the mining structure is processed, this indicates the actual size of the test data set, expressed in number of cases.

 NULL indicates that the mining structure is not processed.

The rowset is sorted on STRUCTURE_CATALOG, STRUCTURE_SCHEMA, STRUCTURE_NAME.

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

Column nameType indicatorRestriction State
STRUCTURE_CATALOGDBTYPE_WSTROptional.
STRUCTURE_SCHEMADBTYPE_WSTROptional.
STRUCTURE_NAMEDBTYPE_WSTROptional.

Data Mining Schema Rowsets

Community Additions

ADD
Show: