CREATE TABLE (Global Temporary/Volatile Table Preservation Clause)
About Deleting or Preserving Global Temporary and Volatile Table Contents
This clause instructs Teradata 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.