>How I can move a table from a database to another database without loosing its proprieties. For example captions, default values, long fields names etc.
>
>Thank in advance
You can use COPY TO filename DATABASE dbcname WITH CDX
You'll retain long names and indexes, at least...
To retain more properties, you can run gendbc and copy the table code out, then run the code on the new dbc, then copy the records...
Either way, then delete the old dbc table...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.