Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 27 Nov 2002 @ 20:58:21 GMT


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


Subj:   Re: SEQUENCES IN Teradata
 
From:   Dieter N�th

Syed Arifuddin wrote:

  I like to know whether we have sequences in Teradata? as we do have in oracle Database. If we do have then whats the syntax and how we can use that.  



In the next release V2R5 (GCA in December) there's an identity column with the proposed SQL:2003 syntax:

idcol integer GENERATED [ALWAYS | BY DEFAULT] AS IDENTITY
(START WITH a INCREMENT BY b
 MINVALUE c MAXVALUE d [NO] CYCLE)

But this is only a kind of table-local sequence like in MS SQL Server. There's also a CREATE SEQUENCE in SQL:2003, so maybe in a later release, ;-)


Dieter



     
  <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