SQL Server - Delete Data using DELETE Statement

Use the DELETE statement to delete data from the existing table in the current schema or tables of the schema on which you have the DELETE privilege.

Syntax:

DELETE FROM table_name [WHERE Condition];

Here we will delete the data in the Employee table shown below.