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 dbadmin 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