DROP EXTENSION

DROP EXTENSION — remove an extension

Synopsis

DROP EXTENSION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

Description

You must own the extension to use DROP EXTENSION.

Parameters

IF EXISTS

Do not throw an error if the extension does not exist. A notice is issued in this case.

name

The name of an installed extension.

CASCADE

Automatically drop objects that depend on the extension, and in turn all objects that depend on those objects (see Section 6.14).

RESTRICT

This option prevents the specified extensions from being dropped if there exists non-extension-member objects that depends on any the extensions. This is the default.

Compatibility

DROP EXTENSION is a LightDB extension.

See Also

CREATE EXTENSION, ALTER EXTENSION