RubyMine 2023.2 Help


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… (>). 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.

    Create a table copy using context menu
  • 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 to see the live example.

    Create a table copy using data editor toolbar

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 .

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

    Copy table structure

Last modified: 28 June 2023