---
title: Make Table Dialog Box
ms.custom: seo-lt-2019
ms.date: 01/19/2017
ms.prod: sql
ms.prod_service: sql-tools
ms.technology: ssms
ms.topic: conceptual
f1_keywords: 
  - "vdtsql.chm:69650"
  - "vdt.dlgbox.maketable"
ms.assetid: 5eb28dc3-828e-486c-9348-596bb5a04c85
author: markingmyname
ms.author: maghan
ms.manager: jroth
ms.reviewer: 

---
# Make Table Dialog Box (Visual Database Tools)
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
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)](../../ssms/visual-db-tools/query-properties-visual-database-tools.md).  
  
## See Also  
[Create Make Table Queries (Visual Database Tools)](../../ssms/visual-db-tools/create-make-table-queries-visual-database-tools.md)  
[Types of Queries (Visual Database Tools)](../../ssms/visual-db-tools/types-of-queries-visual-database-tools.md)