Deletes rows from a table.
| Category: | Data Manipulation |
| Supports: | EXECUTE Statement |
| Data source: | SAS data set, SPD Engine data set, SPD Server, Aster, DB2 under UNIX and PC, Greenplum, MDS, MySQL, Netezza, ODBC, Oracle, PostgreSQL, SAP HANA, Sybase IQ, Teradata |
specifies the table from which you are deleting rows.
| Restriction | If row-level permissions are in effect for the table, you cannot delete rows from the table. Row-level security is available only with SAS Federation Server. See the SAS Federation Server documentation for more information. |
| Tip | You can use '.*' after the table name for compatibility with Microsoft Access tables. |
specifies any valid WHERE clause used to limit the number of rows that are deleted.
| Tip | You can use parameter arrays in the WHERE statement. |
| See | WHERE clause in the SELECT Statement |