Archives of the TeradataForum

Message Posted: Tue, 21 Mar 2001 @ 04:49:32 GMT

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

Hi David:

When creating tables in Teradata, the defined order of the columns is not a concern. The RDBMS will automatically put the VARCHAR columns at the end of the disk record regardless of their defined location within the CREATE TABLE.

Although they physically appear last on disk, the SELECT * will return them in the sequence of the CREATE TABLE.

Hope this helps,

Mike

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