KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Copy and Paste tables in the Structure Editor
PRODUCT: 4D | VERSION: 11.4 | PLATFORM: Mac & Win
Published On: August 13, 2009

4D v11 SQL gives you the ability to copy and paste tables within the structure editor. What happens when you then paste the table depends on where it is pasted. Here are the diferent scenarios:

  1. The copied table is selected.
    Result: The paste will append the copied fields to the end of the table.
  2. Another table is selected,
    Result: The paste will append the copied fields to the end of the selected table.
  3. No table is selected.
    Result: The paste will create a new table named "Copy_of_YOURTABLENAME" with all of the fields of the copied table.

Commented by Thomas Fitch on August 14, 2009 at 3:59 PM
This can be very useful if all your tables share a few fields (such as UUID, Timestamp, etc) or you want to add the same fields to all of your existing tables. A quick copy and paste can add those fields to all your tables.