TERADATA ERROR – DROP DATABASE Failed. 3552:

When attempting to drop a database that I created for temporary use, I received the following error when I ran the “DROP DATABASE < database name >” command:

DROP DATABASE Failed. 3552: Cannot DROP databases with tables, journal tables, views, macros, or zones.

DROP DATABASE Failed 3552

All the objects in the database need to be deleted first, before the database can be dropped.  The “DELETE DATABASE < database name >” will remove all objects existing in the database.  Then the “DROP DATABASE” command can be run successfully.

DELETE DATABASE

Leave a Reply