--- title: Delete 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: - "vdt.dlgbox.deletetable" - "vdtsql.chm:69644" ms.assetid: 56a60bfd-1353-4228-b23e-e887da2228a2 author: markingmyname ms.author: maghan ms.manager: jroth ms.reviewer: --- # Delete Table Dialog Box (Visual Database Tools) [!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../includes/appliesto-ss-asdb-asdw-pdw-md.md)] This dialog box allows you to specify the table from which to delete records. This dialog box appears if more than one table is displayed in the Diagram pane when you change the type of a query to a DELETE query. Select the table to delete records from, and then choose **OK**. > [!NOTE] > A DELETE query removes entire rows from the table. If you want to clear values from individual data columns, use an UPDATE query. If you want to delete columns from a table definition, or delete the table itself, use Table Designer or the database design tools for your database. ## See Also [Remove Tables from Queries (Visual Database Tools)](../../ssms/visual-db-tools/remove-tables-from-queries-visual-database-tools.md)