YMatrix

Version Release History
Platform Requirements

YMatrix

Quick Start

Standard Cluster Deployment

Data Modeling

Connecting to The database

Data Writing

Data Migration

Data Query

Maintenance and Monitoring

Performance Tuning

Troubleshooting

Reference Guide

SQL Reference

FAQ

scenario

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