DataChange rows

Copy table data

Discover how to copy table data without using SQL.

Open a table

In the Connections view, connect to your database, expand the database and Tables, then select a table to open its data grid.

Copy selected cells

Click and drag across the cells you want to copy.

A range of cells selected in the data grid

Right-click the selection and choose Copy to copy the values without headers. To choose a format, open Copy As > Selection, then select the format.

Copy As Selection menu with the available formats

Copy all rows

To copy the complete result set, right-click inside the grid and open Copy As > All, then select a format.

Copy As All menu with the available formats

Available copy formats

Selection includes three range-specific choices:

Without Headers: Cell values only
With Headers: Column names followed by cell values
As Comma List: Values in a comma-separated list

Both Selection and All support:

As CSV: Comma-separated values
As HTML: HTML table markup
As HTML (Styled): HTML table markup with styling
As JSON: Compact JSON
As JSON Pretty: Formatted JSON
As Markdown: A Markdown table
As SQL In Clause: Values formatted for an SQL IN clause
As SQL Insert Statements: SQL INSERT statements
As XML: XML data