Archives of the TeradataForum
Message Posted: Thu, 12 Feb 2004 @ 20:32:19 GMT
| Subj: || || Re: Volatile table existence check |
| From: || || TeradataForum |
A volatile table only exists in your session and is created in your USERNAME database. It exists in your spool. If your username is N12345.
The volatile table is created in your N12345 database.
In most installations Global, Temporary and Perm tables are not created in the USERNAME database so there should not be a conflict.
A volatile table is important to store temporary data that will be used later in the same session.