How to change the auto-increment field start value

[wickyd]

Hi folx

I have a table with an autoinc data type as the primary index. The table starts at number 1.

I want to change the table so that the first record starts at 20986.

Therefore, I want the table to change from:

NUMBER
1
2
3
4
etc...

and become:

NUMBER
20986
20987
20988
20989
etc...

Thank you.

Kind regards
wickyd

 

[PHV]

Any chance you could post some relevant info like, say, the RDBMS ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[wickyd]

DBISAM Version 3.21

 

[PHV]

Have you tried to create a row with value set to 20985, and then delete this row ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244