Deletes all data tables, views, triggers, SQL procedures, macros, and user-installed files (UIFs) from a database.
To delete the definition for the database from the data dictionary, you must use DROP DATABASE. See DROP DATABASE.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Required Privileges
You must have the DROP privilege on the specified database.