Archives of the TeradataForum

Message Posted: Tue, 22 Jan 2008 @ 22:22:46 GMT

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

Try

     create TABLE  db832.table1_xxx
     AS (SELECT * FROM db832.complex_view)
     WITH NO DATA;

You might want to specify a primary index as well.

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