Delete all the records

Question

How to delete all the records in SQL Server 2008?

Answer 1

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 ?'