Delete a Mining Model from a Mining Structure

Applies to: SQL Server 2019 and earlier Analysis Services Azure Analysis Services Fabric/Power BI Premium

Important

Data mining was deprecated in SQL Server 2017 Analysis Services and now discontinued in SQL Server 2022 Analysis Services. Documentation is not updated for deprecated and discontinued features. To learn more, see Analysis Services backward compatibility.

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

1. Select the Mining Models tab in SQL Server Data Tools.

2. Right-click the model that you want to delete, and select Delete.

   The Delete Objects dialog box opens.

3. Click OK.

Delete a mining model using SQL Server Management Studio

1. In SQL Server Management Studio, open the SQL Server Analysis Services database that contains the model.

2. Expand Mining Structures, and then expand Mining Models.

3. 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.

Delete a mining model using DMX

• DROP MINING MODEL (DMX)

See Also

Mining Model Tasks and How-tos