DROP CATALOG

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 10.3 and above

Drops a catalog. An exception is thrown if the catalog does not exist in the metastore.

Syntax

DROP CATALOG [ IF EXISTS ] catalog_name [ RESTRICT | CASCADE ]

Parameters

  • IF EXISTS

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

  • catalog_name:

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

  • RESTRICT

    If specified, will restrict dropping a non-empty catalog and is enabled by default.

  • CASCADE

    If specified, will drop all the associated databases (schemas) and the objects within them.

Examples

-- Create a `vaccine` catalog
> CREATE CATALOG vaccine COMMENT 'This catalog is used to maintain information about vaccines';

-- Drop the catalog and its schemas
> DROP CATALOG vaccine CASCADE;

-- Drop the catalog using IF EXISTS and only if it is empty.
> DROP CATALOG IF EXISTS vaccine RESTRICT;