SQL Server : Deleting All Records from a Table

Problem

You want to delete all the records from a table.

Solution

Use the DELETE command to delete records from a table. For example, to delete all records from EMP:

 delete from emp

Discussion

When using the DELETE command without a WHERE clause, you will delete all rows from the table specified.

** If you want the Full Table detail. Refer the SQL Table in Label List. Or Click here to View the Table