How to: Delete Rows in the Results Pane (Visual Database Tools)
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 How to: 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 Specifying Search Criteria (Visual Database Tools).
To delete a row or rows
Select the box to the left of the row or rows you want to delete in the Results pane.
Press DELETE.
In the message box asking for confirmation, click Yes.
Warning
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
Tasks
How to: Create Delete Queries (Visual Database Tools)
Other Resources
Specifying Search Criteria (Visual Database Tools)