`DROP PREDICTOR` Statement¶

Description¶

The DROP PREDICTOR statement deletes the model table.

Here is the syntax:

DROP PREDICTOR [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.

Let's list all the available predictor tables.

SELECT name
FROM mindsdb.predictors;

On execution, we get:

+---------------------+
| name                |
+---------------------+
| other_model         |
| home_rentals_model  |
+---------------------+

Now we delete the home_rentals_model table.

DROP PREDICTOR 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.predictors table again.

SELECT name
FROM mindsdb.predictors;

On execution, we get:

+---------------------+
| name                |
+---------------------+
| other_model         |
+---------------------+