DROP MINING STRUCTURE (DMX)
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Drops the specified mining structure from the database. All the mining models that are associated with the structure are also dropped from the database.
The following example drops the New Mailing mining structure from the database.
DROP MINING STRUCTURE [New Mailing]