Archives of the TeradataForum
Message Posted: Thu, 26 Feb 2004 @ 17:07:41 GMT
Just wanted to add that the syntax that I was refering to (and assumed) was:
1- CREATE TABLE AS OLDTABLE WITH [NO] DATA;
2- CREATE TABLE AS (SELECT * FROM OLDTABLE) WITH [NO] DATA;
The first option is looking at the table structure for its information and therefore has the table attributes at hand in or to make decisions.
The second is simply a result set which leaves nothing for the DBMS except defaults for set|multiset, journaling and such. Ditto with the primary or secondary index unless if you specify it in the create table statement. But, it does still grab all column attributes.
Sorry for any confusion.
(Don't forget about the 'gotcha' if using a compressed column, in v2r5 in the primary or a secondary index when using the second form. There's a couple of threads on that as well here.)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|