IntelliJ IDEA 2023.1 Help

Copy

Copy table data

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

Create a copy of table data

  • 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.

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

    Use context menu to create a table copy
  • 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.

Copy table structure

  • You can copy the table structure using SQL Generator. To do that, in the Database tool window ( View | Tool Windows | Database), right-click the table and select SQL Scripts | SQL Generator…. Alternatively, press Control+Alt+G.

    For information about the SQL Generator… controls, see Generate DDL definitions for database objects.

Last modified: 21 June 2023