SQL Server DELETE - Remove One or More Rows From a Table
Third, practically speaking, you will rarely remove all rows from a table but only one or several rows. In this case, you need to specify the search_condition in the WHERE clause to limit the number of rows that are deleted.. The rows that cause the search_condition evaluates to true will be deleted.. The WHERE clause is optional. If you skip it, the DELETE statement will remove all rows from ...
DA: 42 PA: 39 MOZ Rank: 80