DMSCHEMA_MINING_STRUCTURES Rowset

Enumerates information on the mining structures in the current catalog.

Rowset Columns

The DMSCHEMA_MINING_STRUCTURES rowset contains the following columns.

Column name Type indicator Length Description

STRUCTURE_CATALOG

DBTYPE_WSTR

The catalog name.

STRUCTURE_SCHEMA

DBTYPE_WSTR

The unqualified schema name. NULL if schemas are not supported by the provider.

STRUCTURE_NAME

DBTYPE_WSTR

The structure name. This column cannot contain NULL.

STRUCTURE_GUID

DBTYPE_GUID

A GUID that uniquely identifies the structure. NULL if not supported by the provider.

DESCRIPTION

DBTYPE_WSTR

A concise description of the structure. NULL if no description is associated with the structure.

STRUCTURE_PROPID

DBTYPE_UI4

The property ID of the structure. NULL if not supported by the provider.

DATE_CREATED

DBTYPE_DBTIMESTAMP

The date when the structure was created. NULL if not available from the provider.

DATE_MODIFIED

DBTYPE_DBTIMESTAMP

The date when the structure was last modified. NULL if not available from the provider.

CREATION_STATEMENT

DBTYPE_WSTR

(Optional) The statement used to create the original data mining model.

IS_POPULATED

DBTYPE_BOOL

A Boolean that indicates whether the structure is populated.

VARIANT_TRUE if the structure is populated; VARIANT_FALSE otherwise.

LAST_PROCESSED

DBTYPE_DBTIMESTAMP

The date when the structure was last processed. NULL if not available from the provider.

The rowset is sorted on STRUCTURE_CATALOG, STRUCTURE_SCHEMA, STRUCTURE_NAME.

Restriction Columns

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

Column name Type indicator Restriction State

STRUCTURE_CATALOG

DBTYPE_WSTR

Optional.

STRUCTURE_SCHEMA

DBTYPE_WSTR

Optional.

STRUCTURE_NAME

DBTYPE_WSTR

Optional.

See Also

Reference

Data Mining Schema Rowsets

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

14 April 2006

Changed content:
  • Updated technical information in many of the column descriptions.