Share via

Duplicating a Table

  • Article

You can make a copy of a table's structure, its stored procedures, trigger expressions, and default field values by using the language. There is no menu option to perform the same function. This procedure does not copy the contents of the table.

To duplicate a table

  1. Open the original table.
  2. Use the COPY STRUCTURE command to make a copy of the original table.
  3. Open the empty table created with the COPY STRUCTURE command.
  4. Use the APPEND FROM command to copy the data from the original table.

See Also

Table Creation | Deleting a Free Table | Copying and Editing Table Structure | Working with Tables | Deleting a Database Table | Saving a Table as HTML | Viewing Data in Tables | Customizing a Browse Window | Customizing Tables