Hi Gary.

>Is there a way to move a table from one database to another without using REMOVE TABLE / ADD TABLE which would mess up long fields names and indexes?

- Use GENDBC to generate the code to recreate the table
- Modify the code to rename the table (because you can't have two tables in the same folder with the same name) and to apply to the other database
- Run it to create the table
- Use APPEND FROM to populate the new table from the old one
- Remove the table from the original database
- Rename the new table back to the old name

Doug