17.10 - After DELETE Structure Remains Intact - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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.