DELETE DATABASE in Teradata

DELETE DATABASE statement can be used to delete all tables, views, triggers, stored procedures, user-defined functions, and macros from the database.

Syntax:
DELETE DATABASE <database name>

Example:
DELETE DATABASE user_info