>>>>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.
>>>
>>>USE Table1
>>>COPY STRUCTURE EXTENDED TO NewTable1
>>>USE Table2
>>>COPY STRUCTURE EXTENDED TO NewTable2
>>>USE NewTable1
>>>APPEND FROM NewTable2
>>
>>I don't see where this achieves what he is asking for... are you saying to build a table off the metadata results you have?
>>
>>Wayne
>
>Here's the original question: "Is there a way to combine structures of 2 dbfs? ".
>
>My suggestion accomplishes what he asked.

I'm sorry, but I don't see where this does what is asked... I get a result table with information about the desired results. It does not create a table with the structure of both original tables combined. Maybe there is one more step?


Wayne