Subject Re: [firebird-support] Maximum number of stored procedures?
Author Ivan Prenosil
> Is there a limit to the number of stored procedures which can be
> contained within a single FB db?

Because RDB$PROCEDURE_ID is just SMALLINT,
the maximum number of procedures is 64k.
(and you better try it, just in case there could be a bug
limiting the number to just 32k).

> While I'm on the topic, are there any
> limits to the number of other db items, eg generators etc?

Check system tables. E.g. RDB$GENERATOR_ID is SMALLINT too,
so the limit is the same.

Ivan