AppCode
 
2023.1
Shortcuts: Windows
Get AppCode
  1. Integrations
  2. Database tools and SQL
  3. Database objects
  4. Tables
  5. Copy

Copy

Last modified: 01 March 2023

You can duplicate a table in the current schema or copy it to another schema or data source.

Create a table copy

  • Drag a table to the node in which you want to create a copy. In the Import <table_name> Table dialog, ensure that mappings are correct and click Import.

    https://resources.jetbrains.com/help/img/idea/2023.1/db_create_table_copy_by_dragging.png
    Gif

  • Right-click a table and select Copy Table to… (F5). In the Choose Target dialog, type the name of a schema in which you want to create a copy. In the Import <table_name> Table dialog, ensure that mappings are correct and click Import.

    https://resources.jetbrains.com/help/img/idea/2023.1/db_create_table_copy_context_menu.png
    Gif

  • In the data editor, click the Copy to Database… icon (Copy to Database) and select a schema to which you want to copy the table.

    Check the video at youtube.com to see the live example.