Global Temporary/Volatile Table Preservation Clause | CREATE TABLE | Vantage - 17.10 - About Deleting or Preserving Global Temporary and Volatile Table Contents - 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)

This clause instructs the database whether to delete or preserve the contents of a global temporary or volatile table when a transaction completes.

DELETE is the default.

This option is valid for global temporary and volatile tables only.

Also see Global Temporary Tables and Volatile Tables.