>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
Tracy