Archives of the TeradataForum

Message Posted: Fri, 18 Jan 2002 @ 13:51:03 GMT

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

This may be not a Teradata assumption but an ANSI assumption. Be that as it may, the correct syntax, as you know, is:

create [set|multiset] table tableA as
(select stuff from tableB ...)
with data;

The expression in parentheses designates a result set, not a table. (For example, DBC.AccLogTbl is a table; (select * from DBC.AccLogTbl) is a result set, not a table.)

In other words, the data you are inserting into your newly created table is simply a set of rows, not an existing table structure.

To put this yet another way: If you coded this:

select *
from DBC.TableSize
where (databasename, tablename) in
(select databasename, tablename from DBC.Tables);

would you expect the subquery to be materialized as a table, with primary index, entries in the Cylinder Index, and all the rest of it? Of course not. It is simply a set of rows. They have to be stored somewhere, of course, but that doesn't make them a table.

--wgr

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