SQL DELETEIT technician command center
● ITSign inMembers
Database · SQL and Database Administration

SQL DELETE

Delete matching rows.

Copy-ready commandSQL DELETE
DELETE FROM users WHERE id = 42;
Production warning

INSERT, UPDATE, DELETE, ALTER, and restore operations can modify or remove data.

Requirements and permissions

Requirements
Appropriate database client and connection
Permissions
Database privileges vary
Last reviewed
2026-07-31

Examples

Basic example

Delete matching rows.

DELETE FROM users WHERE id = 42;

Common errors

Command not found

Confirm Appropriate database client and connection is installed and available in your current shell.