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: [email protected]
[mailto:[email protected]] 
Sent: Friday, December 2, 2016 10:13 AM
To: [email protected]
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
[email protected] <mailto:[email protected]> 
www.carfac.be <http://www.carfac.be%3chttp:/www.carfac.be/>
<http://www.carfac.be/>
[cid:[email protected]]<http://www.facebook.com/groups/12070918
1286476/>[cid:[email protected]]<http://www.linkedin.com/compan
y/hdc-software-nv> [cid:[email protected]]
<https://twitter.com/carfacbvba>

[Beschrijving: Beschrijving: Beschrijving: CarfacAS
(klein)]<http://www.carfac.be/>

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



Reply via email to