Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Comparing Table Structures
Message
 
 
To
12/06/2001 09:29:21
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00518332
Message ID:
00518349
Views:
15
>I'm looking for a simple way to compare the structures of a number of tables. I think they are the same, but there are 200+ fields and I would rather sit and write code for two hours rather than sit and stare at paper for two hours. I'm playing around with the AFields() function, but can't quite get the concept going of what I need to do... Any ideas? Thanks!
>
>Regards, Renoir

You can copy each table structure into dbf using COPY STRUCTURE EXTENDED TO ... and than use SQL-select to retrieve differences.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform