Archives of the TeradataForum
Message Posted: Wed, 27 Nov 2002 @ 20:58:21 GMT
| 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
| 
