Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to delete a nameless table
Message
From
29/11/1999 11:21:27
 
 
To
29/11/1999 08:40:02
General information
Forum:
Visual FoxPro
Category:
Stonefield
Miscellaneous
Thread ID:
00296332
Message ID:
00296380
Views:
19
Hi Peter.

>I somehow (but don't know how) get a table without name into the dbc and into SDT. Now I cannot delete that sucker. If I delete the table the dbc won't open anymore with a dbc inconsistency error.
>the rename and delete options on the right click menu in sdt are greyed out!

Have you done a VALIDATE DATABASE RECOVER? I don't know if it'll catch blank table names or not. If not, I suggest opening the DBC as a table (USE (whatever).DBC), browsing it, and removing the record for the table (look for OBJECTTYPE = "Table" and OBJECTNAME is blank). Then close the table and VALIDATE DATABASE RECOVER to remove any objects (like fields) belonging to the table. Finally, in SDT, click on the Validate Meta Data button to update the meta data.

Doug
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform