15.00 - After DELETE Structure Remains Intact - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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.