Archives of the TeradataForum

Message Posted: Thu, 03 Nov 2005 @ 11:12:09 GMT

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

Have you tried using the "create table ... as ... with data" variation? What does the created table look like using that form of query? Can you publish the table definitions and your queries (it might make it easier to help you)?

Example:

     Create table tst
     As (
         select *
         from the_other_table
         )
     With data;

Refer to the docs for things like specifying Primary indexes et al.

Good Luck

Glenn Mc

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