Removes a database/schema from the system. The physical operations involve removing the metadata for the database from the warehouse.
DROP (DATABASE|SCHEMA) [IF EXISTS] database_name [CASCADE];
The complete name of the database/schema you want to delete
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.
This SQL command does not return anything.