Categories:

User & Security DDL (Third-Party Service Integrations)

DROP INTEGRATION

Removes an integration from the current/specified schema.

See also:

SHOW INTEGRATIONS

Notification integrations

CREATE NOTIFICATION INTEGRATION

Security integrations

CREATE SECURITY INTEGRATION

Storage integrations

CREATE STORAGE INTEGRATION

Syntax

DROP [ { NOTIFICATION | SECURITY | STORAGE } ] INTEGRATION [ IF EXISTS ] <name>

Parameters

name

Specifies the identifier for the integration to drop. If the identifier contains spaces, special characters, or mixed-case characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive (e.g. "My Object").

If the integration identifier is not fully-qualified (in the form of db_name.schema_name.integration_name or schema_name.integration_name), the command looks for the integration in the current schema for the session.

NOTIFICATION | SECURITY | STORAGE

Specifies the integration type.

Usage Notes

  • Dropped integrations cannot be recovered; they must be recreated.

Examples

Drop an integration:

SHOW INTEGRATIONS LIKE 't2%';


DROP INTEGRATION t2;


SHOW INTEGRATIONS LIKE 't2%';

Drop the integration again, but don’t raise an error if the integration does not exist:

DROP INTEGRATION IF EXISTS t2;