Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I get the code used to create a table
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00037407
Message ID:
00037413
Views:
33
>I have a table and I would like to reproduce the structure of it in an SQL command and/or to create a cursor exactly like it.
>
>Is there a way I can do this?

The simplest way is COPY STRUCTURE which replicate structure to new empty table.
Also you can:
1. COPY STRUCTURE EXTENDED creating table containing current table structure info
2. modify this table content, if necessary
3. AFIELDS() to collect structure info into array
4. CREATE CURSOR FROM ARRAY ...
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform