Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition

DELETE

The DELETE statement enables you to remove rows from tables. This statement specifies the table from which rows are to be deleted and criteria for the rows to deleted. Table 21.8 describes the components of a DELETE statement

Table 21.8. Components of a SQL DELETE Statement

Component	Description
DELETE FROM	Specifies the table from which to delete rows
WHERE	Specifies the criteria that determines which rows are to be deleted

Using DELETE to Delete All Rows from a Table

To delete all rows from a table, you need only specify the name of the table from which to delete those rows. The following example shows how to delete all rows from the titles table:

DELETE FROM titles 

NOTE

SQL Server offers another method for removing all rows from a table ...