DROP DATABASE

DROP DATABASE removes a database from your Materialize instances.

WARNING! DROP DATABASE immediately removes all objects within the database without confirmation. Use with care!

Syntax 

DROP DATABASE IF EXISTS database_name
Field Use
IF EXISTS Do not return an error if the specified database does not exist.
database_name The database you want to drop. For available databases, see SHOW DATABASES.

Example 

SHOW DATABASES;