简体中文

DROP EXTENSION

Remove the extension.

Synopsis

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

Description

DROP EXTENSION removes the extension from the database. Deleting an extension will cause its constituent objects to be deleted as well.

Note: The support extension files required to create an extension are not deleted. The file must be deleted manually from the YMatrix database host.

You must have this extension to use DROP EXTENSION.

If any extended objects are being used in the database, this command will fail. For example, if a table is defined with a column of the extension type. Add the CASCADE option to force delete those dependent objects.

Parameters

IF EXISTS

If the extension does not exist, please do not report an error. Give a notice.

name

Name of the installed extension.

CASCADE

Automatically delete objects that depend on extensions and delete all objects that depend on these objects.

RESTRICT

If any object other than the extension member object depends on an extension, the extension is denied. This is the default value.

Compatibility