Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 17 Oct 2005 @ 13:43:18 GMT


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


Subj:   Re: Bugs with identity column
 
From:   Mohommod.Khan

One additional comment on Identity column that you may want to keep in mind that, if you have a Join Index, and you want this column to participate on it, it will not work. Also you can not use 'CREATE TABLE DEST AS SOURCE W/O DATA if there is an Identity column (probably it makes sense, since it is system generated....) . Although I will not call it a bug but rather it is a limitation. What I did, is to create a column and used CSUM to generate it and make it work/look like an identity column rather System generated.


Hope this helps.

Mohommod Khan



     
  <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