- Add the source table or tables to the Diagram pane.
- Convert the default query to a Make Table query by right-clicking in the Diagram or SQL pane, choosing Change, and then choosing Make Table.
- In the Make Table dialog box, type the name of the destination table. The Query Designer does not check whether the name is already in use or whether you have permission to create the table.
To create a destination table in another database, specify a fully qualified table name including the name of the target database, the owner (if required), and the name of the table.
- Specify the columns to copy by adding them to the query. For details, see Adding Columns. Columns will be copied only if you add them to the query. To copy entire rows, choose * (All Columns).
The Query Designer adds the columns you choose to the Column column of the Grid pane.
- If you want to copy rows in a particular order, specify a sort order. For details, see Ordering Query Results.
- Specify the rows to copy by entering search conditions. For details, see Specifying Search Conditions.
If you do not specify a search condition, all rows from the source table will be copied to the destination table.
Note When you add a column to search to the Grid pane, the Query Designer also adds it to the list of columns to copy. If you want to use a column for searching but not copy it, clear the check box next to the column name in the input source window.
- If you want to copy summary information, specify Group By options. For details, see Summarizing Values for All Rows in a Table.
When you execute a Make Table query, no results are reported in the Results pane. Instead, a message appears indicating how many rows were copied.
To create a Make Table query