PyCharm
 
2022.3
Shortcuts: Windows
Get PyCharm
You are viewing the documentation for an earlier version of PyCharm.
  1. Database tools and SQL
  2. Database objects
  3. Tables
  4. Copy

Copy

Last modified: 07 December 2022

Available only in PyCharm Professional: download to try or compare editions

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/2022.3/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/2022.3/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.