Applies to: Databricks SQL Databricks Runtime 10.3 and above
Drops a catalog. An exception is thrown if the catalog does not exist in the metastore.
If specified, no exception is thrown when the catalog does not exist.
The name of an existing catalog in the metastore. If the name does not exist, an exception is thrown.
If specified, will restrict dropping a non-empty catalog and is enabled by default.
If specified, will drop all the associated databases (schemas) and the objects within them.
-- 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;