DROP PROVIDER

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 11.3 LTS and above check marked yes Unity Catalog only

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.

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;