Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Move a table from a database to another
Message
 
To
05/05/1999 08:42:38
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00215284
Message ID:
00215288
Views:
28
>How I can move a table from a database to another database without loosing its proprieties. For example captions, default values, long fields names etc.
>
>Thank in advance

You can use COPY TO filename DATABASE dbcname WITH CDX

You'll retain long names and indexes, at least...

To retain more properties, you can run gendbc and copy the table code out, then run the code on the new dbc, then copy the records...

Either way, then delete the old dbc table...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Reply
Map
View

Click here to load this message in the networking platform