| Subject | Table with no name |
|---|---|
| Author | paultugwell |
| Post date | 2012-11-25T22:22:30Z |
I have managed to create a table with no name and possibly no fields!
There is a record in RDB$RELATIONS where all of the fields are null except RDB$OWNER_NAME and RDB$DEFAULT_CLASS both of which have values in them. Validating the database finds no errors and trying to mend the database indicates that it does not need mending. Backup works but restore produces this message
'This operation is not defined for system tables.unsuccessful metadata update. TABLE .
Can't have relation with only computed fields or constraints.'
Any idea how to delete this table?
There is a record in RDB$RELATIONS where all of the fields are null except RDB$OWNER_NAME and RDB$DEFAULT_CLASS both of which have values in them. Validating the database finds no errors and trying to mend the database indicates that it does not need mending. Backup works but restore produces this message
'This operation is not defined for system tables.unsuccessful metadata update. TABLE .
Can't have relation with only computed fields or constraints.'
Any idea how to delete this table?