O'Reilly logo

Teradata SQL by Tom Coffing, Mike Larkins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 13 - Temporary Tables

“Those who would give up essential liberty to purchase a little temporary safety deserve neither liberty nor safety.”

-Benjamin Franklin

 

There are three types of Temporary Tables

Derived Table

Exists only within a query

Materialized by a SELECT Statement inside a query

Space comes from the User's Spool space

Deleted when the query ends

Volatile

Created by the User and materialized with an INSERT/SELECT

Space comes from the User's Spool space

Table and Data are deleted only after a User Logs off the session

Global Temporary Table

Table definition is created by a User and the table definition is permanent

Materialized with an INSERT/SELECT

Space comes from the User's TEMP Space

When User logs off the session ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required