Ultimate
Copy

Last modified: 29 November 2022

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.cn/help/img/idea/2022.2/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.cn/help/img/idea/2022.2/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.