Re: Initial/reset serial value

ALTER TABLE >table< MODIFY ( >column< SERIAL(>new value<)); The syntax is described in the SQL Syntax Guide under "ALTER TABLE". The key is to remember that SERIAL is a data type and you can find the specific syntax for that in the SQL Reference Guide under the SERIAL data type. HTH, --Chuck > Informix manuals state that "You can use the MODIFY clause to reset > the next value of a serial column (Syntax Guide)" and "The default > serial starting number is 1, but you can assign an initial value, n, > when you create or alter the table (Reference Guide)" -- then fail to > provide the syntax. > > Well, my Informix SQL syntax crystal ball just broke. What is the > syntax for these operations? And exactly where in the documentation > is this? > >