Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to rename a table of a database?
Message
 
 
To
17/12/2006 15:56:10
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01178413
Message ID:
01178431
Views:
14
>>>
>>>No, I'm sorry. However, it looks like the name of the table itself is stored as pure text, so I would take the chance and change it. I suggest that you make sure that the length of the table names are the same.
>>>
>>>Another solution would be to use Gendbc.prg which i in the tools\Gendbc folder. This program creates a program which you can run to regenerate a DBC. This means that you can run Gendbc, change the generated program and run it. To me this sounds like a safer solution.
>>
>>Thank you. I will look into the Gendbc. But it is still disappointing that there is no simple way to change a table name, both physical file name and the name in the database. What good is the RENAME TABLE command then?
>
>AFAIK you can use third party tools, such as Stonefield Database Toolkit, http://www.stonefield.com/sdt.html

I do use SDT. I will check the documentation (if I have any) on how to do it.

Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform