Export (0) Print
Expand All
Expand Minimize

Make Table Dialog Box

Allows you to name a created table that you copy rows to. This dialog box appears when you change a query's type to be a Make Table query. To change a query's type, from the Query Designer menu, point to Change Type, and then click Make Table.


The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.

Table Name

Type the name of the table to create. Query and View 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.


Before you execute the query you can change properties of the table you want to create by modifying them in the Properties window. For details, see Query Properties.

Community Additions

© 2014 Microsoft