Archives of the TeradataForum

Message Posted: Wed, 27 Oct 2010 @ 09:41:20 GMT

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

Hi ,

Below is the syntax for creating the volatile table.

     create multiset volatile table test1 as dbname.tblname with data ;

     create multiset volatile table test as ( select * from dbc.tables ) with
     data on commit preserve rows ;

     Select * from test;

Thanks & regards

Janardhan R

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