Delete In SQL Server

What is Delete Statement in SQL Server?

Delete :-

Delete statement is used for Delets row in a table.

Syntax:-

Delete from Table_name 
Where some_column = some_value

Example:-

Delete from Student
where StudentId ='2'


Note :-
If we cannot used "where" clause in delete statement then it can delete all the records from table.