Deleting All Rows with TRUNCATE TABLE Statement in SQL Server

Q

How To Delete All Rows with TRUNCATE TABLE Statement in SQL Server?

✍: FYIcenter.com

A

If you want to delete all rows from a table, you have two options:

  • Use the DELETE statement with no WHERE clause.
  • Use the TRUNCATE TABLE statement.

The TRUNCATE statement is more efficient the DELETE statement. The tutorial exercise shows you a good example of TRUNCATE statement:

SELECT COUNT(*) FROM fyi_rates
GO
5

TRUNCATE TABLE fyi_rates
GO

SELECT COUNT(*) FROM fyi_rates
GO
0

 

Using INSERT, UPDATE and DELETE Statements in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-30, 686👍, 0💬