And my second time for this note: using the DATABASE clause preserves long fieldnames, but not all of the other extended information. use GenTable or GenDBC to copy the table structure in its entirety.
>Weird. This is twice today this question came up. Anyway, yes. Check out the COPY command:
>
COPY TO FileName [DATABASE DatabaseName [NAME LongTableName]]
>
>>Is there a way to copy a .dbf and .cdx contained in a .dbc (with long file names) into another .dbc without making a free table and losing the long file names?
Erik Moore
Clientelligence