Delete a Mining Model from a Mining Structure
You can delete mining models by using Data Mining Designer, by using SQL Server Management Studio, or by using DMX statements.
Delete a mining model using SQL Server Data Tools
Select the Mining Models tab in SQL Server Data Tools (SSDT).
Right-click the model that you want to delete, and select Delete.
The Delete Objects dialog box opens.
Delete a mining model using SQL Server Management Studio
In SQL Server Management Studio, open the Analysis Services database that contains the model.
Expand Mining Structures, and then expand Mining Models.
Right-click the model you want to delete, and select Delete.
Deleting the model does not delete the training data, only the metadata and any patterns created when you trained the model.