Jump to content


Photo

Reset Autoindex


  • Please log in to reply
1 reply to this topic

#1 joecooper

joecooper
  • Members
  • PipPipPip
  • Advanced Member
  • 358 posts

Posted 28 February 2006 - 02:35 PM

Statements-------- Value
Format -------------dynamic
Rows ---------------0
Next Autoindex--- 6

how do i set the auto index back to 0 ?
Signature:
[/a]
[a href="http://www.planet-so...=1999&lngWId=8" target="_blank"]EzLogin 1.0[/a]
[a href="http://www.essexracers.com" target="_blank"]Essexracers.com[/a]
Msn Messenger: joe@joeyjoe.co.uk

#2 christianmatthew

christianmatthew
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 28 February 2006 - 04:42 PM

[!--quoteo(post=350220:date=Feb 28 2006, 09:35 AM:name=joecooper)--][div class=\'quotetop\']QUOTE(joecooper @ Feb 28 2006, 09:35 AM) View Post[/div][div class=\'quotemain\'][!--quotec--]
Statements-------- Value
Format -------------dynamic
Rows ---------------0
Next Autoindex--- 6

how do i set the auto index back to 0 ?
[/quote]


I'm no expert; but if worst comes to worst I believe emptying the table will set it back to 0. As in "Empty" rather then delete all the data.
SQL:
TRUNCATE TABLE <TABLENAME>




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users