>ALTER TABLE TableName1 ADD | ALTER [COLUMN] FieldName1
> FieldType [( nFieldWidth [, nPrecision])] [NULL | NOT NULL] [CHECK lExpression1 [ERROR cMessageText1]]
> [AUTOINC [NEXTVALUE NextValue [STEP StepValue]]]

Thanks, I was not aware there was the nextvalue syntax.