I have a table with ten fields,
f1 (being an integer field) to
f10 (being a character field). In between there are other integer, character and date fields.
I would like to copy those field definitions to another table, without needing to re-write the whole definitions. I'm working with the Data Dictionary, who seems not to cover this feature.
Edit after first answer
The first answer mentions how to do this at runtime, but I'm specifically looking for a solution at design-time.
I've found there are different commandline utilities which can be used for working with Progress database:
ProDB for creating a new database,
ProUtil for doing several tasks (but I don't find a
ProUtil <add a field to a table>).
How can I achieve this?