>>>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?
This structure was setup in VFP5, you could not do this in VFP3. (source Hackers Guide to VFP 6.0)
Tracy
Tracy