Archives of the TeradataForum
Message Posted: Wed, 06 Mar 2002 @ 10:11:00 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|