Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 15 Mar 2006 @ 21:41:19 GMT


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


Subj:   Re: AUTO_NUMBER in Teradata
 
From:   Sharma, Vikas

Hey Nitin

Thnaks for enquiring . Tell me abt it .

Not really used c-sum but we have a solution with row_number(). But the problem is that some business users are using MSACCESS as the front end so they can simply add or delete or update table from Access directly without having to write queries in Teradata .

Is it a good idea first of all to define an customer_number primary key field based on identity column .

Secondly if people make copies of this table and come back to insert /update or recreate the table they Are loosing the original numbers.


Rgds

Vikas



     
  <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