Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 26 Feb 2004 @ 17:07:41 GMT


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


Subj:   Re: CREATE TABLE...AS and when SIs are created.
 
From:   Greg Bourgoin

Just wanted to add that the syntax that I was refering to (and assumed) was:

1- CREATE TABLE AS OLDTABLE WITH [NO] DATA;

and not:

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.)



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023