Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

autoincrement

Status
Not open for further replies.
crystalnewbie

crystalnewbie

MIS
Mar 10, 2004
53
US
If a column is set to autoincrement, is it possible for there to be gaps in the sequence, assuming no one has deleted any records or anything done on the properties of the autoincrement field?

I was informed that if the database was restarted the autonumber jumps 1000.

For example, an ID field is set to autoincrement and the last record in the table has the value of 3500 for the ID field. Upon restart of the db, the next record written to the table will have an id number of 4500.

Is this accurate?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top