DROP MODEL

Removes a model from the Vertica database. You can drop multiple models at one time.

Important: Before using a machine learning function, be aware that all the ongoing transactions might be committed.

Syntax

DROP MODEL [IF EXISTS] [[db-name.]schema.]model-name 

Parameters

IF EXISTS

Specifies not to report an error if one or more of the models to drop does not exist. This clause is useful in SQL scripts where you want to drop a model if it exists before recreating it.

[db‑name.]schema

Specifies a schema. If multiple schemas are defined in the database, include the schema name. For example:

myschema
model‑name The model to drop.

Privileges

Any user who creates a model can drop or alter his or her own model. If you are the user, you can drop or alter any model in the database.

Examples

This example shows how you can remove a model.

=> DROP MODEL mySVMModel;
DROP MODEL