>
ALTER TABLE MyTable ALTER COLUMN MyColumn AUTOINC NEXTVALUE 0 STEP 1
Thanks for all the help,
I was trying to go down this route but kept getting syntax errors.
I had to add the field type and field width to the statement which seemed kind of ridiculous because you can't have anything else but an integer in an autoinc field.
ALTER TABLE MyTable ALTER COLUMN MyColumn i(4) AUTOINC NEXTVALUE 50 STEP 1
Thanks again,
Michael Brennan-White
Send me an email when the shouting stops