>>>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.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer