Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Another ALTER TABLE question
 
From:   Sam Mosley

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023