Setting the increment value n for auto-increment field?

[irkmiller]

I have a table with an auto-increment column. I’d like to set it to increment at a value of n for each new record rather than 1. Is this possible? I’ve tried a few SQL statements to alter the table/column, but they all fail. Using HSQLDB Embedded.

[RobertG]

Not with internal HSQLDB. Will always increment 1. For other databases you have to create a sequence generator instead of using the internal AutoValue.

Why do you want to increment more than 1?

[irkmiller]

Something I was taught a long time ago when I was a programmer. Allows space for insertion of record(s) without disrupting the sequence.

[RobertG]

You could use internal Firebird instead. Have a look for CREATE SEQUENCE
Firebird: Create Sequence