Copying database fields

[Cyont]

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, 2005 by Guest

[mr_vodka]

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

[Cyont]

That's encouraging!

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

Cyont

[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