I don't know if this is a silly question, but I need somebody's help on this.

For QA purpose, we need to create new database tables exactly copying from the original tables. The problem is since each table has about 60 - 100 field names, creating fields one by one for each table would be really time-consuming. Also we need to make sure these copied tables keep the same data types as the original ones. I checked Export/Import functions, but it looks they are for data record transference purposes rather than for data structure.

So is there a way to copy table fields from one table to another?

Please let me know.

Cyont

Edited September 26, 200520 yr by Guest

FM8 now does this. FM7 you would have to recreate individual fields.

That's encouraging!

I've just downloaded and installed the FM 8 trial version. Would you be more specific on how to?

Cyont

With other relational databases such as MS SQL, I can easily "Generate SQL Script" from the current table and run it to create a new table with the same columns. I am wondering if FM can do such trick.

Cyont