Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

Make Table Dialog Box (Visual Database Tools)

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.

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.

NoteNote

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 (Visual Database Tools).

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.