Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best way to rename huge table in database w/long field names
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Best way to rename huge table in database w/long field names
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Network:
SAMBA Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01000680
Message ID:
01000680
Views:
78
I know this may seem trivial to some, but I'm drawing a blank today and need to get this done. What are the command(s) that the Project Manager uses to rename a table (and it's dbf files) when you right click on the table and choose "Rename"?

I want to be able to do this in a program without having the project open.

I know I can do a "copy to" with the database name, but this is nearly a 2G table and don't want to wait for it to copy and then have to delete/drop the old one.

The "rename table" command just creates an alias and the dbf file name stays the same - not what I need either.

The table of course also has long field names that I don't want to rebuild if I were to drop the table, rename the dbf files and re-add the table to the database.

So how does the Project Manager do it and what are the command(s) I can use in a .prg to achieve the same results?

TIA
Next
Reply
Map
View

Click here to load this message in the networking platform