Subject Re: tablename length
Author legrand_legrand_63
--- In IB-Conversions@yahoogroups.com, "Claudio Valderrama C."
<cvalde@...> wrote:
>
> > -----Original Message-----
> > From: IB-Conversions@yahoogroups.com
> > [mailto:IB-Conversions@yahoogroups.com]On Behalf Of bloreuser
> >
> > While i am creating tables with lengthy names(25char>) in FB .It's
> > giving error table name length is more than database column length.is
> > it possible to set anywhere?how?
>
> Please take general tech questions to firebird-support at
yahoogroups.com;
> this list was created only to handle conversions from something to FB.
>
> The current limit is 31 bytes for database object names.
>
> C.
>
Yes, Firebird has a limitation for table names length (of 31 Bytes)
but only at creation time !

You can perform SQL queries like
select * from A234567890123456789012345678901xxxx;
on table A234567890123456789012345678901 (31 bytes long table name)

Regards
PAscal