Teradata Delete Database and Drop Database

DELETE DATABASE and DELETE USER statements delete all data tables, views, and macros from a database or user. The database or user remains in the Teradata Database as a named object and retains the available space. None of that space is any longer in use. All space used by the deleted objects becomes available as spool space until it is reused as perm space.
You must have DROP DATABASE or DROP USER privilege on the referenced database or user to delete objects from them. The database or user that you are dropping cannot own other databases or users.

 

If you want to drop an database in teradata, you should execute the below SQL, it will be easy to do.

But TAKE CARE...

Delete database XXX;

Drop database XXX;