15.00 - 3552 Cannot DROP databases with tables, journal tables, views, or macros. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

3552 Cannot DROP databases with tables, journal tables, views, or macros.

Explanation:

The user tried to drop a database or a user when one or more tables, journal tables, views, or macros existed in that database.

Generated By:

OPT modules.

For Whom:

The DBA and the End User.

Remedy:

Drop the underlying tables, or issue a DELETE DATABASE statement to drop all the underlying tables. And, if there is a journal table in the database, then use MODIFY DATABASE to drop it. Resubmit the request.