That's right. But I want to use identity fields because such fields don't uses a generator and a trigger. How can I easily change my old autoincrement fields to identity fields ?

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
 




-----Oorspronkelijk bericht-----
Van: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Verzonden: vrijdag 18 november 2016 10:38
Aan: firebird-support@yahoogroups.com
Onderwerp: Re: [firebird-support] problem - change autoincrement fields to identity fields

18.11.2016 8:56, Nico Speleers - Carfac BVBA nico.speleers@... [firebird-support]
wrote:

> 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?

Give up. Identity is also just a generator and trigger, no difference.


--
WBR, SD.


------------------------------------

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links