DROP PROVIDER

Drops a Delta Sharing provider. An exception is thrown if the provider does not exist in the system.

To execute this statement you must own the provider or be metastore administrator.

Since: Databricks Runtime 11.1

Syntax

DROP PROVIDER [ IF EXISTS ] provider_name

Parameters

  • IF EXISTS

    If specified, no exception is thrown when the recipient does not exist.

  • provider_name

    The name of an existing provider in the system. If the name does not exist, an exception is thrown.

Examples

-- Drop the provider
> DROP PROVIDER other_corp;

-- Drop the provider using IF EXISTS.
> DROP PROVIDER IF EXISTS other_corp;