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.
-----------------------------------------------------------------
Paul Lee ........... Abri Technologies .........
http://abri.com/ 'Recover' - top rated FoxPro/dBase file repair utility.