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


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