DROP DATABASE/SCHEMA

Removes a database/schema from the system. The physical operations involve removing the metadata for the database from the warehouse.

Syntax

DROP (DATABASE|SCHEMA) [IF EXISTS] database_name [CASCADE];

<database_name>

The complete name of the database/schema you want to delete

CASCADE

When you do not use the CASCADE clause, drop all the objects inside the database manually before dropping the database itself.

The CASCADE clause to make drop all tables and other objects in the database before dropping the database itself.

Output

This SQL command does not return anything.