a apiary.
← All tools

SQL / BROWSER UTILITY

SQL DELETE Builder

Generate DELETE statements with configurable conditions and a warning before copying an unrestricted deletion.

Processed locally in your browser. Your SQL is not uploaded or executed.

Enter names, not expressions. Use dialect quotes around names with spaces. Ordinary Oracle names use uppercase; ordinary PostgreSQL names use lowercase. Text values are escaped, never executed.

WHERE conditions

Conditions are combined from top to bottom, with explicit parentheses. Remove all conditions only if you intend to affect every row.

Apiary never executes SQL. Review the statement against your database before using it. Oracle treats empty text as NULL. SQLite uses type affinities and does not enforce declared text lengths or decimal precision.

Good to know

Combine conditions to identify the rows to delete. Without a WHERE clause every row is affected, and copying requires acknowledgement. Apiary never executes SQL.

Example: Delete products where product_id equals 42.