Archives of the TeradataForum
Message Posted: Sun, 07 Nov 2004 @ 19:41:51 GMT
| Subj: | | Re: Create table as in V2R5 |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Sunday, November 07, 2004 13:06 -->
"CREATE TABLE AS tablename" copies most attributes of the source table (one notable exception being SET/MULTISET).
"CREATE TABLE AS (subquery)" does not. You are logically creating the table based on a spool file (result set), which does not carry forward
all the attributes of the tables. That's true even if the query expression is a simple select from a single table.
| 
