- Explore
- Collaborate
- Visualize
- Connect
- Pricing
How to Delete Data in SQL Server
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;