Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
14 April 2006 |
|