> Even if you could use DDL templates, maintaining 100+ triggers just for the purpose of auto incrementing keys is not efficient.
>
> So I'm guessing there is no other solution to this? Oh well, time to switch to oracle.

Oracle doesn't have an auto-increment data type either. At least in
Oracle 10g. Not sure if this has changed in V11. ;-)


--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!