Re: SERIAL seed value

On May 20, 11:38am, Nigel C. Myers wrote: > Subject: Re: SERIAL seed value > Actually, what I am looking for is a way to retrieve the starting number for > values in a SERIAL column. For example, if a column was defined as SERIAL(1001), > how can I get the '1001' value? > >-- End of excerpt from Nigel C. Myers Nigel, My apologies Nigel, I misunderstood your post. Its not an ideal solution but if you are needing to know the initial "seed value" then the following select would return both the inital value and the last value used... select min(column_name), max(column_name) from table_name I do percieve one problem here however. If data is removed from the table in question and perhaps transferred out into an archive table/database then you would lose the "initial seed" value by using a select. I *don't know* if its stored in the systables but someone from Informix may be able to confirm this. sandys