Archives of the TeradataForum

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

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

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