Archives of the TeradataForum

Message Posted: Wed, 23 Jan 2008 @ 13:18:01 GMT

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

<-- Anonymously Posted: Wed, 23 Jan 2008 07:20 -->

Thanks to Christopher Gleeson and Andy Baker.

The code below works just fine.

     create TABLE  db832.table1_xxx
     AS
     (
     select col1,col2 from db832.complex_view
     )
     WITH NO DATA

     primary index(picol1,picol2)
     ;

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