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

Teradata Database SQL Data Definition Language Detailed Topics

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

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.