Java DB - Reset auto-increment primary key

[ash neet]

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]

Try:

   ALTER TABLE table_name ALTER COLUMN auto_increment_column_name RESTART WITH 8

Here is documentation:
http://db.apache.org/derby/docs/10.6/ref/rrefsqlj81859.html

[ash neet]

Hey Thank you so much. It Worked!!