>>COPY TO newtable DATA dbname WITH CDX && if any indexes
>
>Bruce --
>
>1. I would also add the NAME clause so that the "long" table name gets put into the target database.
>
>2. I've noticed one shortcoming with this approach, though (in 5.0a) -- some things (column names, default values, etc.) do not get copied, so you have to MODIFY STRUCTURE on the target table and add them in by hand. It may be that I have been doing something wrong here, but if I am, I haven't figured it out yet.

Yes, I just gave the basic command structure, but you might need to use the NAME clause, as you say. Also, as you say, you'll lose most DBC properties with COPY TO. It's for quick & simple tasks...

Another little gotcha with it I've had is trying to shuffle tables between DBCs with the same name and different paths. There's confusion over which dbc is the one in the DATA clause. I've had to resort to renaming one DBC to get the job done...so there are some caveats about COPY TO DATA, no doubt about it...