Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Combining structures
Message
De
15/10/1999 17:23:53
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00277099
Message ID:
00277128
Vues:
25
You can use COPY STRUCTURE EXTENDED to create a table with the specifications to enable you to recreate the original table. If you do this with both table1 and table2, then append the extended structure of table2 to the extended structure of table1, you could CREATE TABLE FROM the appended to extended structure table and end up with an empty table the structure of whick is the combination of the structures of the original two tables. Beware! There can't be duplicate field name entries in the extended structure table or CREATE TABLE FROM will fail.
HTH

>Is there a way to combine structures of 2 dbfs? I want table1 to be able to append the structure of table2 to it. I do not see anything in the help about this.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform