YMatrix

Quick Start

Cluster Deployment

Data Model

Data Writing

Data Query

SQL Reference

Maintenance and Monitoring

Tool Guide

Troubleshooting

Scenario
Version Release History

DROP EXTENSION

Remove the extension.

Summary

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

describe

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