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?