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.

要访问此命令...

将表格或查询拖放到其他数据库文件窗口的表格部分。

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.