I only use the property Identity to make an autoincrement field and I don't 
make use of generators. Therefore 'How can I reset an autoincrement field in 
firebird 3 ? I used identity to make an autoincrement field' ?

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.spele...@carfac.com
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/>



Van: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Verzonden: vrijdag 2 december 2016 16:34
Aan: firebird-support@yahoogroups.com
Onderwerp: RE: [firebird-support] reset autoincrement field


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> 
[mailto:firebird-support@yahoogroups.com]
Sent: Friday, December 2, 2016 10:13 AM
To: firebird-support@yahoogroups.com<mailto: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.spele...@carfac.com<mailto:nico.spele...@carfac.com>
www.carfac.be<http://www.carfac.be/<http://www.carfac.be%3chttp:/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]



[Non-text portions of this message have been removed]

  • [f... Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support]
    • ... 'Zoran' zoran...@gmail.com [firebird-support]
      • ... Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support]
        • ... 'Zoran' zoran...@gmail.com [firebird-support]
    • ... Norbert Saint Georges n...@tetrasys.eu [firebird-support]
    • ... Helen Borrie hele...@iinet.net.au [firebird-support]

Reply via email to