Re: How do we get serial field starting values for a table using dbschema.

Posted in 1994

Jonathan Leffler — 2 May 1994 11:33:06 -0400 — source: Informix-list mailing list archive (1991-1998)

Succinctly, No. The starting value for a SERIAL column is not preserved anywhere. Once any data has been inserted, there is no way for any of the software to tell what value was set. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: shyam@robadome.com (Shyam Davuburu) >Subject: How do we get serial field starting values for a table using dbschema. >Date: 29 Apr 1994 18:05:20 GMT >X-Informix-List-Id: <news.6551> > > I have created table x with a serial field starting value (301). But >when I run dbschema, the create table statement does not have the 301 >starting value for the serial field. Is there a way we tell dbschema to >generate those values?