DROP DATABASE (Databricks SQL)

Drops a database (schema) and deletes the directory associated with the database from the file system. An exception is thrown if the schema does not exist in the system.

Syntax 

DROP { DATABASE | SCHEMA } [ IF EXISTS ] database_name [ RESTRICT | CASCADE ]

Parameters

  • DATABASE | SCHEMA

    DATABASE and SCHEMA mean the same thing, either of them can be used.

  • IF EXISTS

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

  • database_name: The name of an existing database (schema) in the system. If the name does not exist, an exception is thrown.

  • RESTRICT

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

  • CASCADE

    If specified, will drop all the associated tables and functions.

Examples 

-- Create `inventory_db` Database
> CREATE DATABASE inventory_db COMMENT 'This database is used to maintain Inventory';

-- Drop the database and it's tables
> DROP DATABASE inventory_db CASCADE;

-- Drop the database using IF EXISTS
> DROP DATABASE IF EXISTS inventory_db CASCADE;