Vertica Analytics Platform Version 9.2.x Documentation

DROP LIBRARY

Removes a shared library from the database. The library file is deleted from managed directories on the Vertica nodes. The user defined functions (UDFs) in the library are no longer available. See Developing User-Defined Extensions (UDxs) in Extending Vertica for details.

Syntax

DROP LIBRARY [ IF EXISTS ] [[database.]schema.]library [  CASCADE]

Parameters

IF EXISTS

Specifies not to report an error if the library to drop does 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.

library

The name of the library to drop, the same name used in CREATE LIBRARY to load the library.

CASCADE

Drops any functions that were defined using the library. DROP LIBRARY fails if CASCADE is omitted and one or more UDFs use the target library.

Privileges

Superuser

Examples

=> DROP LIBRARY MyFunctions CASCADE;