Copy

Discover how to copy table data without using SQL.

Discover how to copy table data without using SQL.

Opening a Table

  1. Connect to Database: Start by opening a connection from the DB Explorer pane.

    Selecting a database connection
    Connect to your database from the DB Explorer

  2. Select a Database: After selecting a connection, choose a specific database.

    Selecting a database
    Choose the specific database containing your tables

  3. Open a Table: Expand Tables by double-clicking, then click on a specific table. This will open the table in a new tab.

    Selecting a table
    Navigate to and open the table you want to work with

Copying a Selection

  1. Select a range: Click and drag over the cells you want to copy. You can also select all cells by right-clicking and choosing Select All.

  2. Copy: Right-click the selection to open the context menu, then hover over Copy and select Selection.

    Copy selection menu
    Right-click and choose Copy to access copy options

  3. Choose a format: The Selection submenu shows all available formats. Choose Without Headers for plain data, With Headers to include column names, or pick a specific format like CSV, JSON, or Markdown.

    Copy selection with format options
    Choose a format from the Selection submenu

Copying All Rows

To copy every row in the table, right-click and choose Copy > All, then select your preferred format.

Copy all rows menu
Copy all rows using Copy > All

The All submenu provides the same export formats, applied to the entire table rather than just your selection.

Copy all rows with format options
Choose a format when copying all rows

Available Copy Formats

When copying a Selection, you can choose from:

  • Without Headers: Copies cell values only
  • With Headers: Includes column headers above the data
  • As Comma List: Values as a comma-separated list

Both Selection and All support these formats:

  • As CSV: Comma-separated values for spreadsheets and data tools
  • As HTML: HTML table markup for embedding in web pages
  • As JSON: JSON format for web development and APIs
  • As JSON Pretty: Formatted JSON for readability
  • As Markdown: Markdown table for documentation
  • As SQL In Clause: Values formatted for SQL IN clauses
  • As SQL Insert Statements: SQL INSERT statements for re-inserting data
  • As XML: XML format for structured data exchange