Re: Start values for serial columns

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? DAS -- David Snyder @ Snide Computer Services - Folcroft, PA Current Release is db4glgen-3.9 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com