Archives of the TeradataForum
Message Posted: Wed, 27 Oct 2010 @ 08:52:21 GMT
<-- Anonymously Posted: Wednesday, October 27, 2010 03:40 -->
I've been trying to create a volatile table from another table as shown below:
create volatile table testvolatile as (select * from database.table ) with data ;
This creates the table but it's empty. I've tried a variety of variations on the syntax including adding 'on commit preserve rows' after the close bracket but without success. Is it possible to create a volatile table from another table or do I need to create it from scratch and then insert my data.
Syntax examples would be appreciated.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|