Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Another ALTER TABLE question
From:   Lee Vickers

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?


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020