DELETE (DMX)
Clears a mining model, a mining structure, or a mining structure and all its associated mining models, depending on the Data Mining Extensions (DMX) clauses that you use.
Syntax
DELETE FROM [MINING MODEL] <model>[.CONTENT]
DELETE FROM [MINING STRUCTURE] <structure>[.CONTENT]|[.CASES]
Arguments
- model
A model identifier.
- structure
A structure identifier.
Remarks
If you do not specify MINING MODEL or MINING STRUCTURE, Analysis Services searches for the object type based on the name, and processes the correct object. If the server contains a mining structure and a mining model that have the same name, an error is returned.
The following table describes the result of using different forms of the syntax.
| Statement | Result |
|---|---|
DELETE FROM MINING STRUCTURE<structure> or DELETE FROM MINING STRUCTURE<structure>.CONTENT |
Performs ProcessClear on the mining structure. All the content is cleared from the mining structure and its associated mining models. |
DELETE FROM MINING STRUCTURE<structure>.CASES |
Performs ProcessClearStructureOnly on the mining structure. All the content is cleared from the mining structure, leaving its associated mining models intact. Drillthrough on the associated mining models will fail after the mining structure has been cleared. |
DELETE FROM MINING MODEL<model> or DELETE FROM MINING MODEL<model>.CONTENT |
Performs ProcessClear on the mining model but leaves the state values intact. State values are the possible states of a column. For example, state values for a gender column would be male and female. |
For more information about processing types, see Type Element (XMLA).
Examples
The following example removes all of the content from the NB_Sample model.
DELETE FROM NB_Sample.CONTENT
See Also
Reference
Data Mining Extensions (DMX) Data Definition Statements
Data Mining Extensions (DMX) Data Manipulation Statements
Data Mining Extensions (DMX) Statement Reference