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

Database and schema. The default schema is public. 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.