Deletion in SQL Server

This blog defines how to delete a table in SQL Server.

--if you want to delete all the rows from the "ABC" table, then,

delete ABC

--if you want to delete certain specific rows, then,

delete ABC where columnname=xyz

--all you need to do is write your condition in the where clause