Archives of the TeradataForum

Message Posted: Tue, 08 Apr 2003 @ 16:52:52 GMT

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

Jim,

perhaps the problem is that you have to use WITH DATA clause, if you want to create a populated table and WITH NO DATA if you just need DDL.

e.g.:

create table tab1 as ( select * from .....) WITH DATA; --> populate
create table tab1 as ( select * from .....) WITH NO DATA; --> only
creates DDL

Cheers

Sergio Azzaretti

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