DELETE queries delete data from a database. It is important to note that using a DELETE statement without a WHERE clause will delete all records held in a table.

If you have accidently deleted data from database tables in MS SQL Server, you can restore the deleted data (tables) using Log Sequence Number (LSN). But for this, you need the transaction backup file ...