Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Comparing Table Structures
Message
 
 
À
12/06/2001 09:29:21
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00518332
Message ID:
00518349
Vues:
16
>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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform