| Subject | RE: [firebird-support] reset autoincrement field |
|---|---|
| Author | Zoran |
| Post date | 2016-12-02T15:34:20Z |
To see current generator value
select gen_id(generator-name, 0) from rdb$database
To set generator value
set generator generator-name to value;
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Friday, December 2, 2016 10:13 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] reset autoincrement field
How can I reset an autoincrement field in firebird 3 ? I used identity to make an autoincrement field.
Thanks.
Nico Speleers
Analyst
Carfac bvba
Driving on experience
Rijksweg 53
9680 Maarkedal
Tel. +32 55 23 00 00
Fax +32 55 31 00 95
nico.speleers@...
www.carfac.be<http://www.carfac.be/>
[cid:image001.jpg@01D11613.C23F19C0]<http://www.facebook.com/groups/120709181286476/>[cid:image002.jpg@01D11613.C23F19C0]<http://www.linkedin.com/company/hdc-software-nv> [cid:image003.jpg@01D11613.C23F19C0] <https://twitter.com/carfacbvba>
[Beschrijving: Beschrijving: Beschrijving: CarfacAS (klein)]<http://www.carfac.be/>
[Non-text portions of this message have been removed]