Learn the basic syntax and examples of the SQL DELETE statement, as well as its limitations and alternatives, for deleting data from a table in a relational database.

Any return code or message that is generated by the DBMS is available in the macro variables SQLXRC and SQLXMSG after the statement executes. See SQL Procedure Pass-Through Facility Return Codes for ...

If your server is a SAS/CONNECT single-user server, you can also use RSPT to send non-query SQL statements to a remote DBMS. For example, proc sql; connect to remote (server=sunserv dbms=oracle); ...

The native PL/SQL insert statement in the first example actually generates a recursive SQL statement--'insert into mytestvalues(:1)'--and binds the values on each iteration.