Archives of the TeradataForum

Message Posted: Thu, 26 Aug 2004 @ 13:15:29 GMT

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

That is because when you use 'as select' syntax you can select fewer columns , also may change the order of the columns from the table. Therefore TD uses its create table prognosis and defaults to the defaults for the unspecified optionals.

-- Sankar

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