15.00 - CREATE TABLE (Global Temporary/Volatile Table Preservation Clause) - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

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.

Also see “Global Temporary Tables” on page 512 and “Volatile Tables” on page 513 and pages following.