​
Description

The DROP MODEL statement deletes the model table.

​
Syntax

Here is the syntax: 
DROP MODEL [IF EXISTS] predictor_name;
On execution, we get: 
Query OK, 0 rows affected (0.058 sec)
Where:
NameDescription
predictor_nameName of the model to be deleted.

​
Example

Let’s list all the available predictor tables. 
SELECT name
FROM mindsdb.models;
On execution, we get: 
+---------------------+
| name                |
+---------------------+
| other_model         |
| home_rentals_model  |
+---------------------+
Now we delete the home_rentals_model table. 
DROP MODEL home_rentals_model;
On execution, we get: 
Query OK, 0 rows affected (0.058 sec)
We can check if the deletion was successful by querying the mindsdb.models table again. 
SELECT name
FROM mindsdb.models;
On execution, we get: 
+---------------------+
| name                |
+---------------------+
| other_model         |
+---------------------+