DROP SOURCE

Drops a User Defined Load Source function from the Vertica catalog.

Syntax

DROP SOURCE [[database.]schema.]source()

Parameters

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

source() Specifies the source function to drop. You must append empty parentheses to the function name.

Privileges

Non-superuser:

Example

The following command drops the curl source function:

=> DROP SOURCE curl();
DROP SOURCE