Invalid modify request. unsuccessful metadata update ERASE RDB$RELATIONS failed cannot delete system tables.The table is not a system table. The table does not have a detail table. I have another table in the database that I can drop with no trouble. What's going on?
SELECT RDB$RELATION_ID, RDB$RELATION_NAME, RDB$SYSTEM_FLAG FROM RDB$RELATIONS WHERE RBD$RELATION_NAME = 'mytable.gdb'(Where "mytable.gdb" is the name of the table you are unable to drop.)
UPDATE RDB$RELATIONS SET RDB$SYSTEM_FLAG = 0 WHERE RDB$RELATION_NAME = 'mytable.gdb'If RDB$RELATION_ID is less than 256 (condition 2 above), then run this query
UPDATE RDB$RELATIONS SET RDB$RELATION_ID = 9999 WHERE RDB$RELATION_NAME = 'mytable.gdb'After running the appropriate query, you should be able to drop your table.
Last Modified: 15-OCT-02