Re: Start values for serial columns

Dave Snyder writes: >Quoting Malcolm Apps... >} >} I've recently been working on a small project that will recreate a >} database schema *exactly* - down to the names of tablespaces etc and >} especially the initial values of any serial columns. >} >} I've scoured the system catalogs and can't find the information >} required for serial columns anywhere. >} >Having worked with the low-level C-ISAM stuff... I don't see anywhere >that the initial SERIAL number is stored. The serial number is stored >in the .idx file. I would assume that when a table is created, the >initial value is written to the file. As rows are added, the serial >value is incremented. It seems that after you start adding rows, >the initial serial value is lost forever. Can anyone at Informix confirm >or deny this observation? Mr. Snyder's observation is correct. The initial serial value is not preserved anywhere. Dave -- Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney