Models
Remove a Model
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:
| Name | Description |
|---|---|
predictor_name | Name of the model to be deleted. |
Example
Let’s list all the available predictor tables.
SHOW 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.
SHOW MODELS;
On execution, we get:
+---------------------+
| name |
+---------------------+
| other_model |
+---------------------+
Was this page helpful?