Drop/ Delete Database in Teradata

Question

Please help with direction on how to drop a database in Teradata.
When I run the command DROP DATABASE database_name, I get the error message:

*** Failure 3552 Cannot DROP databases with tables, journal tables, 
views, macros, or zones.
            Statement# 1, Info =0
*** Total elapsed time was 1 second.

Answer 1

You need to run this command first to delete all of the objects in the database:

DELETE DATABASE database_name;

In order to drop a database with journal tables:

MODIFY DATABASE database_name AS DROP DEFAULT JOURNAL TABLE;

Then run,

DROP DATABASE database_name

to delete the database in Teradata