DELETE (DML)
Summary
The DELETE command removes rows of data from a table.
Syntax
DELETE FROM <schema_name.table_name> [WHERE]; |
Details
Use a WHERE clause to only delete rows that match certain criteria.
Connect’s DELETE supports a narrower set of syntax choices compared to those found in many relational databases. DELETE does not allow the use of correlated subqueries or joins to other tables. Use a series of SELECT statements and working tables to logically perform more complexDELETE operations.
Connect restricts DELETE operations to tables found in the staging, delta, and any custom schemas. The xactly and xdms schemas are read only for all users.
Examples
delete from staging.order_item;
delete from staging.person
where action = ‘save version’;
