Archives of the TeradataForum

Message Posted: Sun, 09 Dec 2012 @ 10:31:04 GMT

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

Good point Dave, but something that gets overlooked when doing create table as select * you lose any defaults and compression and soft RI if it exists. Same as if you select from a view to create table. Just wanted to add this as a to remember.

Cheers

barb

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