Stefan Balzter wrote:

>
> I understand that there is no way of creating and populating a table
> within a single transaction? Dito for creating foreign keys in other
> tables that refer to the newly created table?

Right.

>
> If I'm right, does this have a reason?

Yes. Tables are permanent global structures visible to
other connections. The SQL standard describes temporary
tables and a future version of Firebird will support them.

Regards,


Ann