wood burning stoves 2.0*
The moose likes JDBC and the fly likes Java DB - Reset auto-increment primary key Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Java DB - Reset auto-increment primary key" Watch "Java DB - Reset auto-increment primary key" New topic
Author

Java DB - Reset auto-increment primary key

ash neet
Ranch Hand

Joined: Dec 21, 2010
Posts: 33
Hey Everyone,

Can anyone please tell me how do i reset the auto-increment primary key in Java DB (Embedded java)? I am using Squirrel SQL Client for creating database.
Ireneusz Kordal
Ranch Hand

Joined: Jun 21, 2008
Posts: 423
Try:
Here is documentation:
http://db.apache.org/derby/docs/10.6/ref/rrefsqlj81859.html
ash neet
Ranch Hand

Joined: Dec 21, 2010
Posts: 33
Hey Thank you so much. It Worked!!
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Java DB - Reset auto-increment primary key
 
Similar Threads
autoincrement invoice
Java DB - Delete all records in a table.
Getting primary keys
MySQL resetting auto-increment
set the values