Copy Query or Table by Drag-and-Drop

Dragging-and-dropping a query or table opens the Copy Table dialog, which allows you to define the options for copying a query or a table.

To access this command...

Drag and drop a table or a query into the table part of another database file window.

With the Copy Table dialog you can:

copy the data from the table into another table,
use the structure of the table as the basis for creating a new table.

You can copy within the same database or between different databases.

Copy Table

You can copy a table by dragging and dropping the table onto the table area of a database file window. The Copy table dialog appears.

Apply columns

In the data source explorer, you can copy a table by dragging and dropping the table onto the table container. The Apply columns dialog is the second window of the Copy table dialog.

Type formatting

In the data source explorer, you can copy a table by dragging and dropping the table onto the table container. The Type formatting dialog is the third window of the Copy table dialog.