delete-rows-in-the-results-pane-visual-database-tools.md

title	Delete Rows in the Results Pane
ms.custom	seo-lt-2019
ms.date	01/19/2017
ms.prod	sql
ms.prod_service	sql-tools
ms.technology	ssms
ms.topic	conceptual
helpviewer_keywords	View Designer, Results pane removing rows row removal [SQL Server], Visual Database Tools Results pane row deletions [SQL Server], Visual Database Tools Results pane Query Designer [SQL Server], Results pane deleting rows Results pane
ms.assetid	a1147905-fe4a-4fac-b576-a17622477e66
author	markingmyname
ms.author	maghan
ms.manager	jroth
ms.reviewer

Delete Rows in the Results Pane (Visual Database Tools)

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] Delete rows in the Results pane if you want to delete records in the database. If you want to delete all of the rows you can use a Delete query. For more information see Create Delete Queries (Visual Database Tools). If you only want to remove rows from the Results pane, change the criteria for the query. For more information see Specify Search Criteria (Visual Database Tools).

To delete a row or rows

1. Select the box to the left of the row or rows you want to delete in the Results pane.

2. Press DELETE.

3. In the message box asking for confirmation, click Yes.

Caution

Rows you delete in this way are permanently removed from the database and cannot be recalled.

Note

If any of the selected rows can't be deleted from the database, none of them will be deleted and you will receive a message telling you which rows can't be deleted.

See Also

Create Delete Queries (Visual Database Tools)
Specify Search Criteria (Visual Database Tools)