15.00 - Volatile Tables and the Default Database - 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)

Volatile Tables and the Default Database

When you create an unqualified volatile temporary table, the login user space is used as the default database for the table, whatever the default database is currently specified to be.

When you create a qualified volatile table, the database name you specify must be identical to that of the login user database. Otherwise, the system returns an error.