> >Actually, 31 characters for object names, less for constraint names.
>
> I've heard this rumour about short contraint name limits too, but I can't
> get Firebird to reject a 31-character constraint name.

In fact it is table name that should be restricted.

Security class name in RDB$SECURITY_CLASSES table
is created as concatenation of 'SQL$' and table name,
and the result should fit into 31 characters (and if not,
it is silently trimmed).

If you have two tables whose names have identical first 27 characters,
they overwrite each other's security classes. (discovered by Claudio)

Ivan