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.