How to Drop Teradata database with all objects

Following Way, we can drop a Teradata Database:

1. Delete all the objects in the database

2. Delete child database if there any

3. Drop the database

Example:

In that example we would like to drop database UV2Ax

Following way, we can drop UVAx database

drop database ITAxCRMBI;

Drop database UV2AxCRMBI;

delete database ITAxCRMBI

Drop database UV2Ax;

Might be useful:

5780 Cannot DROP a user or database that has DBQL enabled

3552 Cannot DROP databases with tables, journal tables, views, macros, or zones

3551 The user cannot DROP a database that has descendants