Archives of the TeradataForum
Message Posted: Mon, 21 Apr 2003 @ 16:59:02 GMT
On Fri, 11 Apr 2003 11:55:43 -0400, Anomy Anom wrote:
For all who is thinking of SEQUENCE kind of feature, here is some info: Teradata DBS(version >= V2R5.0) now supports a a new feature called "Identity Column Support"(IDC). IDC column attributes are mentioned during create table statement to a column.
Eg of a create table stmt with idc column:
CREATE SET TABLE MLD.t ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL ( x INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1000 INCREMENT BY 10 MINVALUE 0 MAXVALUE 300000 NO CYCLE), y INTEGER) UNIQUE PRIMARY INDEX ( x );
Check: help 'data_type attributes' for syntax of 'generated' attribute.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|