Autonumber

[realstandman]

I have a table where I need an autonumber to start at 30000. With this in mind I will be using a
DELETE test.*
FROM test;

and Reloading this table with new data. How can I get the Autonumber to restart at 30000??

Thanks, Stan

 

[realstandman]

Or is there a way to create a number starting at 30000 that incriments up 1 for each line?

STan

 

[PHV]

ALTER TABLE yourTable ALTER COLUMN yourautonumber COUNTER(30000,1);

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

 

[realstandman]

Works like a charm!!!