• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Reset the Auto Number Column

 
Sri Gnana
Ranch Hand
Posts: 166
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi friends,
I want to reset the Auto Number Coloumn , I'm using MSAccess,can any one help me?
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
As I remember this is a feature of the access application itself, not SQL so you can't do it through JDBC. But then this is a sort of DBA task, so you shouldn't do it through JDBC anyway.
 
Sri Gnana
Ranch Hand
Posts: 166
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Paul
Thanks, i did it.Just i delete the auto number column and again create a new column.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic