>>>>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
OK. Thanks. You're right. The help documentation in VFP5 is incorrect
for COPY STRUCTURE..... Thats what threw me off.
Not worried about VFP3 - very few people use it.
-----------------------------------------------------------------
Paul Lee ........... Abri Technologies .........
http://abri.com/ 'Recover' - top rated FoxPro/dBase file repair utility.