Subject | problem - change autoincrement fields to identity fields |
---|---|
Author | Nico Speleers - Carfac BVBA |
Post date | 2016-11-18T07:56:18Z |
Hello,
I want to change my autoincrement fields made in firebird 2.5.4 (with generator and trigger) to an identity field in firebird 3.0.1 without the generator and trigger. Can someone give me an useful script or another solution?
We work in an superserver model and our data access interface is FB Maestro 15.11.0.4.
Thanks in advance.
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]
I want to change my autoincrement fields made in firebird 2.5.4 (with generator and trigger) to an identity field in firebird 3.0.1 without the generator and trigger. Can someone give me an useful script or another solution?
We work in an superserver model and our data access interface is FB Maestro 15.11.0.4.
Thanks in advance.
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]