Archives of the TeradataForum

Message Posted: Wed, 07 Mar 2002 @ 01:13:22 GMT

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

Lee,

Columns are assigned a columnid in the data dictionary. (see view DBC.COLUMNS) They increment by one starting with the first column in the table. (note: they don't start with columnid = 1, but increment by 1 from the starting number). Therefore, when you add a column it gets the previous max(columnid) + 1. So, the order in which columns are defined to the table, including alters has an impact. The advice on using views to return the columns in a desirable order is good advice. Most shops don't give any direct table access to users, requiring all user access to be through views.

Sam Mosley

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