DELETE (DMX)

Applies to: SQL Server Analysis Services

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

Data Mining Extensions (DMX) Data Definition Statements
Data Mining Extensions (DMX) Data Manipulation Statements
Data Mining Extensions (DMX) Statement Reference