Copy Query or Table by Drag-and-Drop

Dragging-and-dropping a query or table opens the Copy Table dialogue box, 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 dialogue box 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 dialogue box 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 dialogue box is the second window of the Copy table dialogue box.

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 dialogue box is the third window of the Copy table dialogue box.