The SQL Procedure

DELETE Statement

Removes one or more rows from a table or view that is specified in the FROM clause.

Restriction: You cannot use DELETE FROM on a table accessed via an engine that does not support UPDATE processing.

Featured in: Combining Two Tables

DELETE

FROM table-name|sas/access-view|proc-sql-view <ASalias>

<WHEREsql-expression>;

Arguments

alias: assigns an alias to table-name, sas/access-view, or proc-sql-view.
sas/access-view: specifies a SAS/ACCESS view that you are deleting rows from.
proc-sql-view: specifies a PROC SQL view that you are deleting rows from.
sql-expression: See sql-expression .
table-name: specifies the table that you are deleting rows from.

Deleting Rows Through Views
You can delete one or more rows from a view's underlying table, with some restrictions. See Updating PROC SQL and SAS/ACCESS Views .

CAUTION:: If you omit a WHERE clause, the DELETE statement deletes all the rows from the specified table or the table described by a view.

Chapter Contents
Previous
Next
Top of Page

Restriction:	You cannot use DELETE FROM on a table accessed via an engine that does not support UPDATE processing.
Featured in:	Combining Two Tables