How to Use SQL Server delete from Statement

To delete rows in a SQL Server table, use the DELETE statement:

delete from sessions where id = 10;

The WHERE clause is optional, but you'll usually want it, unless you really want to delete every row from the table.

delete from sessions;
database icon
From SQL Server query to chart to Slack in seconds
Get to answers faster, together, with PopSQL and SQL Server