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