Subject | Unable to drop tables and fields |
---|---|
Author | klmsw45 |
Post date | 2011-05-07T22:07:46Z |
Out of a database (.fdb) of about 200 tables, I am unable to drop 3 of the tables. I have dropped all the fields, triggers, indexes, foreign keys, checked the dependancies tab (which says there are none) on the 3 offending tables and yet I keep getting this error:
Starting transaction...
Preparing query: ALTER TABLE JET_TSK_CND DROP PAR_GUID
Prepare time: 0.016s
Plan not available.
Executing...
Done.
168 fetches, 11 marks, 1 reads, 1 writes.
0 inserts, 1 updates, 1 deletes, 33 index, 0 seq.
Delta memory: 43684 bytes.
RDB$RELATION_FIELDS: 1 deletes.
RDB$RELATIONS: 1 updates.
Commiting transaction...
*** IBPP::SQLException ***
Context: Transaction::Commit
SQL Message : -607
This operation is not defined for system tables.
Engine Code : 335544351
Engine Message :
unsuccessful metadata update
cannot delete
COLUMN JET_TSK_CND.PAR_GUID
there are 2 dependencies
Total execution time: 0.016s
I have run gix to check and fix errors, and I have done a backup and restore. Nothing I do will allow me to drop these fields/tables.
Is there something I can do in the system tables to remove any identifiers that is telling Firebird that these fields/tables have depenancies when actually they don't. OR is there a system table I can go into to at least *look up* what is supposidly depending on these fields/tables ? And then change it so I can drop them?
Thanks in advance for any help you can provide.
Starting transaction...
Preparing query: ALTER TABLE JET_TSK_CND DROP PAR_GUID
Prepare time: 0.016s
Plan not available.
Executing...
Done.
168 fetches, 11 marks, 1 reads, 1 writes.
0 inserts, 1 updates, 1 deletes, 33 index, 0 seq.
Delta memory: 43684 bytes.
RDB$RELATION_FIELDS: 1 deletes.
RDB$RELATIONS: 1 updates.
Commiting transaction...
*** IBPP::SQLException ***
Context: Transaction::Commit
SQL Message : -607
This operation is not defined for system tables.
Engine Code : 335544351
Engine Message :
unsuccessful metadata update
cannot delete
COLUMN JET_TSK_CND.PAR_GUID
there are 2 dependencies
Total execution time: 0.016s
I have run gix to check and fix errors, and I have done a backup and restore. Nothing I do will allow me to drop these fields/tables.
Is there something I can do in the system tables to remove any identifiers that is telling Firebird that these fields/tables have depenancies when actually they don't. OR is there a system table I can go into to at least *look up* what is supposidly depending on these fields/tables ? And then change it so I can drop them?
Thanks in advance for any help you can provide.