 |
 |
Archives of the TeradataForum
Message Posted: Wed, 20 Jun 2007 @ 15:50:40 GMT
| Subj: | | Re: Mload script to copy data from 1 table to another table in Teradata |
| |
| From: | | Fred W Pluebell |
If you are going to use CREATE AS to copy a table, it's generally better to use the "AS existingTableName" syntax.
Whenever you use "AS (SELECT ...)" you should always include primary index specification at a minimum; even if the subquery is "SELECT *" from
a single table, attributes of the underlying table(s) don't get copied when the data source is a query / spool file.
| |
