Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Removing a deleted table from the DBC
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01185922
Message ID:
01186018
Vues:
22
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform