DROP SHARE

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

Drops a share. An exception is thrown if the share does not exist in the system. To drop a share you must be its owner.

Syntax

DROP SHARE [ IF EXISTS ] share_name

Parameters

  • IF EXISTS

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

  • share_name

    The name of an existing share. If the name does not exist, an exception is thrown.

Examples

-- Create `vaccine` share
> CREATE SHARE vaccine COMMENT 'This share is used to share information about vaccines';

-- Drop the share
> DROP SHARE vaccine;

-- Drop the share using IF EXISTS.
> DROP SHARE IF EXISTS vaccine;