| title | Make Table Dialog Box (Visual Database Tools) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 06/13/2017 | ||
| ms.prod | sql-server-2014 | ||
| ms.reviewer | |||
| ms.technology | ssms | ||
| ms.topic | conceptual | ||
| f1_keywords |
|
||
| ms.assetid | 5eb28dc3-828e-486c-9348-596bb5a04c85 | ||
| author | stevestein | ||
| ms.author | sstein | ||
| manager | craigg |
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.
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).
Create Make Table Queries (Visual Database Tools)
Types of Queries (Visual Database Tools)