DROP DATABASE/SCHEMA
Removes a database/schema from the system. The physical operations involve removing the metadata for the database from the warehouse.
Syntax
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.