IDENTITY Field

Posted in 2000

Marc — Thu, 14 Sep 2000 11:16:19 GMT — source: Informix-list mailing list archive (1991-1998)

Does Informix DBMS support the IDENTITY field type, like SQL Server or Access? Thank you!!

↪ replying to Marc

Vardan Aroustamian — Thu, 14 Sep 2000 15:39:53 GMT — source: Informix-list mailing list archive (1991-1998)

In article <7s2w5.166142$Z05.1649378@telenews.teleline.es>, "Marc" <lucas@ole.com> wrote: > Does Informix DBMS support the IDENTITY field type, like SQL Server or > Access? > > Thank you!! > > Yes, it is 'serial'. There are differences though. For example increment is always 1. Regards -- Vardan Aroustamian vaar@geocities.com Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to Marc

Art S. Kagel — Thu, 14 Sep 2000 14:49:13 -0400 — source: Informix-list mailing list archive (1991-1998)

Marc wrote: > > Does Informix DBMS support the IDENTITY field type, like SQL Server or > Access? I assume an IDENTITY is not a field that can only contain the value '1'. If that is an auto generated unique key use the Informix type SERIAL or SERIAL8 if you have IDS.2000. Art S. Kagel