Archives of the TeradataForum

Message Posted: Wed, 06 Mar 2002 @ 10:11:00 GMT

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

I realise that in physical terms, columns have no order within an RDB. However, the logical order of these columns is defined within the table DDL. This sequence is both useful and important to us;

- For grouping related measures together within a table,

- To repeat the same sequence of measures across tables of different summary levels.

This makes all inserts into the tables easy to write and maintain, also, anyone doing a SELECT * will see the columns in the order specified in the DDL.

If you do an explain on an ALTER TABLE.....ADD statement, you will see that some DBC tables are inserted into (TVFields, TVM.....). I'm assuming that these tables hold the table definition. Therefore, is it possible to make ALTER TABLE insert into these DBC tables so that the new column is placed in logical position n, rather than always at the end?

Lee

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