Clone Table Specifications with GetTableDef
The GetTableDef operation allows you to copy column specifications from an existing table into your new table. This is useful because tables in the same database often have identical data columns that are frequently used for joins and views. By copying the column specifications from one table to another, you ensure that these repeating columns all have the same data type, column width, and null and default values.
To copy column specifications from an existing table
1. Select the GetTableDef operation.
You are prompted for a table name.
2. Enter the name of the table whose specifications you want to copy.
The column specifications for that table are copied into the Column Specification form. You can copy columns from more than one table into the new table column specifications.
3. Use the Delete and Move operations to eliminate column specifications you do not need and to modify the column order.
Last modified date: 08/28/2024