Multiple Ways to Delete Rows. As you can see there are multiple ways to delete rows from a SQL Server table. You can use the WHERE clause to identify specific criteria for the rows that need to be deleted. You can join a table to the table in which you are deleting rows to identify which rows to delete. read more
SQL > SQL Commands > Delete From Statement The DELETE FROM statement in SQL is used to remove records from a table. Please note that the DELETE FROM command cannot delete any rows of data that would violate FOREIGN KEY or other constraints. read more
To delete rows in a heap and deallocate pages, use one of the following methods. Specify the TABLOCK hint in the DELETE statement. Using the TABLOCK hint causes the delete operation to take an exclusive lock on the table instead of a row or page lock. This allows the pages to be deallocated. read more