auto-increment field

answered 2020-06-06 18:05:58 +0100

Ratslinger
26546 ●9 ●35 ●135

Hello,

Please include basic information when posting. Database type can be critical. Here is for HSQLDB embedded to reset to any value an auto-increment field:

alter table TABLE_NAME alter FIELD_NAME restart with 1;

Run this from menu Tools->SQL on an empty table.

edit flag offensive delete link

Comments

How can I do this with a brand new HSQLDB embedded database where I want to add an ID field? Do I have to run this SQL before I start?

Tripple Delta ( 2020-06-06 18:09:12 +0100 )edit

Has nothing to do with a new database This has to do with each individual table. Once a table is defined then simply run this SQL (with your field & table names).

Also as eluded to, this is used to set the next increment number to any starting point. For example if numbers are to start at '300'.

Ratslinger ( 2020-06-06 18:18:51 +0100 )edit

add a comment

1 Answer

Comments

Question Tools

Stats

Related questions

auto-increment field edit

1 Answer

Comments

Question Tools

Stats

Related questions

auto-increment field