Copy

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.

   

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

   

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

   

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.

   

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.

   

Copying All Rows

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

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

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