Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. If you only want to remove rows from the Results pane, change the criteria for the query. For more information, see Specify search criteria.
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, select Yes.
Caution
Rows you delete in this way are permanently removed from the database and can't be recalled.
Note
If any of the selected rows can't be deleted from the database, none of them are deleted, and you receive a message telling you which rows can't be deleted.