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

Comments