15.00 - After DELETE Structure Remains Intact - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

After DELETE Structure Remains Intact

After all the data tables, views, triggers, stored procedures, user‑defined functions, and macros have been deleted from a database, the structure of the emptied database remains intact, as if its CREATE statement had just been performed, and it can be used in a subsequent restore operation. The DELETE DATABASE statements is used when a database has been only partially restored and is not in a usable state.