Auto Increment

[madvalpreston]

Hi

Is there a way to start the AI field at a specific number. I would like the live version of a table to start at 1000.

Is this possible and how do I achiceve it. It is for a table called tablequote with a field called idqoute

Thanks

 

[r937]

try this --

ALTER TABLE MYTABLE AUTO_INCREMENT = 1000;

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon