DROP MODEL

Removes one or more models from the Vertica database.

Syntax

DROP MODEL [ IF EXISTS ] [[database.]schema.]model[,…]

Parameters

IF EXISTS

Specifies not to report an error if the models to drop do not exist. Use this clause in SQL scripts to avoid errors on dropping non-existent objects before attempting to create them.

[database.]schema

Specifies a schema, by default public. If schema is any schema other than public, you must supply the schema name. For example:

myschema.thisDbObject

If you specify a database, it must be the current database.
model The model to drop.

Privileges

One of the following:

  • Superuser
  • Non-superuser: model owner

Examples

See Dropping Models in Analyzing Data.