• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. SQL Reference
  5. SQL Syntax
  6. DROP EXTENSION

DROP EXTENSION

Function

DROP EXTENSION deletes extensions from the database.

Precautions

The syntax is only available in extended mode (when GUC parameter support_extended_features is on). Exercise caution when enabling the mode. It is used for tools like internal upgrade tools. Common users should not use the mode.

Syntax

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

Parameter Description

  • IF EXISTS

    Sends a notice instead of an error if the specified extension does not exist.

  • name

    Specifies the name of an extension to be deleted.

  • CASCADE | RESTRICT
    • CASCADE: automatically deletes objects that depend on the extension to be deleted.
    • RESTRICT (default): refuses to delete the extension if any objects depend on it.