>>>Anyone got a quick way to remove table references in a DBC after the table has been deleted? Or do I need to USE the DBC and do it manually?
>>>TIA
>>
>>You could use REMOVE TABLE command. This way all references will be cleared.
>
>Edward,
>the problem is that if the table does not exist then remove table generates an error and does not remove the reference. Same thing with drop table.
Then (backup first!) try validating the database. It should complain that the table is missing, and offer to remove references to it. Mmmm... maybe, haven't had such a situation in years.
If that fails, open the dbc as a table, find your missing table's record, delete any records that have its PK as a parent key, then delete that record too, pack the dbc, and try validating again. If it's mentioned anywhere in the RI code... well, you'll have to edit that manually. Any persistent relations where it was involved should just be deleted.