Delete all the records

How to delete all the records in SQL Server 2008?

To delete all records from a table without deleting the table.

DELETE FROM table_name use with care, there is no undo!

To remove a table

DROP TABLE table_name

from a table?

You can use this if you have no foreign keys to other tables

truncate table TableName

or

delete TableName

if you want all tables

sp_msforeachtable 'delete ?'

Use the DELETE statement

Delete From <TableName>

Eg:

Delete from Student;

I can see the that the others answers shown above are right, but I'll make your life easy.

I even created an example for you. I added some rows and want delete them.

You have to right click on the table and as shown in the figure Script Table a> Delete to> New query Editor widows:

Then another window will open with a script. Delete the line of "where", because you want to delete all rows. Then click Execute.

To make sure you did it right right click over the table and click in "Select Top 1000 rows". Then you can see that the query is empty.

If you want to reset your table, you can do

truncate table TableName

truncate needs privileges, and you can't use it if your table has dependents (another tables that have FK of your table,