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