Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 17 Dec 2004 @ 12:05:52 GMT


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


Subj:   Re: Specification of 'Cycle' and 'Start with' option of identity column
 
From:   Narayan Murthy

With the positive increment and a max value defined - when you have a "cycle" clause the id column will either re-start from the min value (if defined) else will start with the min value of the column data type.

- If the max value was not defined and with a cycle clause it would re-start after having reached the max value of the particular data type

- but again it would restart either from the min value(if specified) or the min value of the column data type.


Rules governing the "START WITH" is, that it should either be

- <= Max value (or <= max value of the particular column data type)

- >= Min value (or >= min value of the particular column data type)


And Identity column feature is said to be ANSI SQL-99 compliance.


Narayan



     
  <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