>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.