Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Removing a deleted table from the DBC
Message
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:
01186018
Views:
21
This message has been marked as the solution to the initial question of the thread.
>>>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.

OPEN your database exclusively.

Then do VALIDATE DATABASE RECOVER

it will give you the option to remove the missing table.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform