List:General Discussion« Previous MessageNext Message »
From:Jason Pruim Date:August 29 2007 4:38pm
Subject:Reset a auto increment field?
View as plain text  
Is there away to reset an auto incrementing field count? I have a  
database that currently has 935 records in it but because I have  
deleted a few the current number used for NEW records is 938 :) How  
can I get it to count the records and assign a record number based on  
the total count?

Hope that makes sense! Thanks for looking! :)

--

Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424
www.raoset.com
japruim@stripped



Thread
Reset a auto increment field?Jason Pruim29 Aug
  • Re: Reset a auto increment field?Shawn Green29 Aug
    • Re: Reset a auto increment field?Jason Pruim29 Aug
      • Re: Reset a auto increment field?Shawn Green29 Aug
      • RE: Reset a auto increment field?Jerry Schwartz29 Aug
Re: Reset a auto increment field?dpgirago29 Aug
  • RE: Reset a auto increment field?emierzwa29 Aug
    • Re: Reset a auto increment field?Jason Pruim29 Aug
      • RE: Reset a auto increment field?emierzwa29 Aug
      • RE: Reset a auto increment field?Jerry Schwartz29 Aug