Delete all the records

Question

How to delete all the records in SQL Server 2008

User · Answer

When the table is very large  it s better to delete table itself with drop table TableName and recreate it  if one has create table query  rather than deleting records one by one  using delete from statement because that can be time consuming

User · Answer

Use the DELETE statement  Delete From  lt TableName gt    Eg    Delete from Student

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

For one table  truncate table  table name    For all tables  EXEC sp MSforeachtable  command1  truncate table

User · Answer

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

[sql] Delete all the records

Examples related to sql

Examples related to sql-server-2008