>>Is(are) there a simple command(s) to copy a table structure with all its indexes to another table retaining long names and index properties (unique, primary, etc.)
>>
>>For example, I have customer.dbf in database maindata.dbc and want to create an empty table customer2.dbf with same field and tag properties in maindata.dbc.
>>
>>COPY STRUCTURE WITH CDX TO customer2
>>only creates free tables and loses long name index properties, etc.
>
>If you expand that statement
>COPY STRUCTURE TO customer2 WITH CDX DATABASE cDatabase NAME cLongTableName
OK. Thanks. That works for VFP6+.
Is there a simple method for VFP5 too?
-----------------------------------------------------------------
Paul Lee ........... Abri Technologies .........
http://abri.com/ 'Recover' - top rated FoxPro/dBase file repair utility.