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

Help and Information

Getting SQL Server 2005 Assistance