binaryseti wrote:

>
>
> Is there a way to reorder the rdb$relation_names in rdb$relations.

Relation id's are issued in the order that the tables are defined.
Changing them is most unwise. Two critical system tables, RDB$FORMATS
and RDB$PAGES are driven off the relation id. If they don't match
RDB$RELATIONS, your database won't work. You could try (I guess) (on a
database you don't care about) changing the relation ids in those three
places, but I suspect the result will be garbage.

>
> I would like the order of tables to be backed up and restored
>

Out of curiosity, why?

> and I see that gbak uses the rdb$relation_id to do so.

A better alternative would be to build a custom gbak that does what you
want.

> If I change the id what other systems tables will need to be updated?

See above. And get a good backup before you start.

Regards,


Ann