Subject | Re: [firebird-support] Identity |
---|---|
Author | Milan Babuskov |
Post date | 2010-12-21T08:51:41Z |
sqlsvr wrote:
Create a regular integer or bigint field and select "autoincrement"
option. The tool will create the needed sequence+trigger for it.
Contrary to what you might think, there is no maintenance cost for that
trigger. If you ever decide to drop the table, the trigger will be
dropped automatically as well.
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================
> How do I create an autoincrement identity field for each table in Firebird (simple way)?In any decent admin. tool (even FlameRobin):
Create a regular integer or bigint field and select "autoincrement"
option. The tool will create the needed sequence+trigger for it.
Contrary to what you might think, there is no maintenance cost for that
trigger. If you ever decide to drop the table, the trigger will be
dropped automatically as well.
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================