Archives of the TeradataForum
Message Posted: Tue, 21 Mar 2001 @ 04:49:32 GMT
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|