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