Release History
Help

YMatrix

Quick Start

Deployment

Data Usage

Manage Clusters

Security

Best Practice

Technical Principles

Advanced Features

Guide

SQL Reference

FAQ

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

DROP EXTENSION is a YMatrix database extension.

See also

ALTER EXTENSION, CREATE EXTENSION

← Previous
DROP_DOMAIN
Next →
DROP_EXTERNAL_TABLE