Delete Rows in the Results Pane (Visual Database Tools)

Applies to: SQL Server

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)