Archives of the TeradataForum

Message Posted: Thu, 12 Feb 2004 @ 20:32:19 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>