Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Removing a deleted table from the DBC
Message
From
16/01/2007 13:45:41
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01185922
Message ID:
01186008
Views:
36
>>>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.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform