Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement