Hi,

> so if you add a table to the db, you need to go around and increase the

size

> of all your references to this variable? How is that efficient?

Not the total number of tables in the db, but the number of tables
involved.

For example, a view that joins three tables has a RDB$DB_KEY
length of 3 * 8 (see RDB$RELATIONS.RDB$DBKEY_LENGTH
column).

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com