| View previous topic :: View next topic |
| Author |
Message |
Vodoley3
General User
Joined: 11 Mar 2012
Posts: 5
|
 Posted: Wed Apr 11, 2012 11:37 pm Post subject: [SOLVED] Multi-mode database - adding autoincrement |
 |
|
Hi,
I am using a Multi-mode database. In one table, my identity field suddenly does not autoincrement anymore. After I checked it, the AutoValue option is set to NO.
How can I reset it to YES and restart at , say, 1000 ?
(something like alter table "table" alter column "ID " autovalue = true ) ?
Last edited by Vodoley3 on Thu Apr 12, 2012 12:07 am; edited 1 time in total |
|
| Back to top |
|
 |
probe1
Moderator
Joined: 18 Aug 2004
Posts: 2465
Location: Chonburi Thailand Asia
|
| Posted: Wed Apr 11, 2012 11:48 pm Post subject: Re: Multi-mode database - adding autoincrement |
|
|
| Vodoley3 wrote: | | I am using a Multi-mode database. |
Syntax depends on database you use. See the documentation there.
For OOo-BASE embedded HSQLDB ( v1.8 )
Reset to a number
| Code: | | alter table "Tabelle1" alter column "id" restart with 1000 |
re-assign autoincrement
| Code: | | alter table "Tabelle1" alter column "id" identity |
_________________
Cheers
Winfried
My Macros
DateTime2 extension: insert date, time or timestamp, formatted to your needs |
|
| Back to top |
|
|
dacm
Super User
Joined: 07 Jan 2010
Posts: 734
|
|
| Back to top |
|
|
|
