| Subject | Create System Table | 
|---|---|
| Author | Alan McDonald | 
| Post date | 2007-11-11T03:04:49Z | 
If I do this (after creating an ordinary table):
UPDATE RDB$RELATIONS SET RDB$SYSTEM_FLAG=1 WHERE
RDB$RELATION_NAME='MY$ORDINARYTABLE';
I end up with a table which is not immediately visible in the list of tables
but accessible in all other ways. It does not, however, persist a
backup/restore cycle.
Is there another update on system tables which makes this table persist?
Is the backup process dominated by a hardwired list of system tables? Or is
it the restore which ignores this table?
regards
Alan McDonald
            UPDATE RDB$RELATIONS SET RDB$SYSTEM_FLAG=1 WHERE
RDB$RELATION_NAME='MY$ORDINARYTABLE';
I end up with a table which is not immediately visible in the list of tables
but accessible in all other ways. It does not, however, persist a
backup/restore cycle.
Is there another update on system tables which makes this table persist?
Is the backup process dominated by a hardwired list of system tables? Or is
it the restore which ignores this table?
regards
Alan McDonald