SQL Server Transact Basic to Expert - Delete Query (Whole records)

This blog shows how to use the delete statement in order to delete the contents of the table. In this sample we are going to delete all the records from the table instead of deleting a single record as of our previous blog

Syntax:

Delete FROM table

Example:

Delete from emptable

This deletes all the values in the table