General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only