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
|