• Article

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.

Options

  • 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.

    Note

    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).