Drop a Database or User | VantageCloud Lake - Dropping a Database or User - Teradata Vantage

Dropping a database or user is a two-step process:

1. Delete all database objects from the specified database or user. For example:

   DELETE DATABASE used_cars ALL;

   or

   DELETE USER marco ALL;

2. Drop the empty database or user. For example:

   DROP DATABASE used_cars;

   or

   DROP USER marco;

If a journal table exists, first be sure that no data table references it. Then, remove it. For example:

MODIFY DATABASE used_cars AS DROP DEFAULT JOURNAL TABLE;

The database or user permanent space that the drop makes available is added to the permanent space of the immediate owner database or user.