MS SQL Server Concepts and Programming Question: Download Questions PDF
How To Delete All Rows with TRUNCATE TABLE Statement in MS SQL Server?
![MS SQL Server Interview Answer MS SQL Server Interview Question](https://globalguideline.com/public/images/interview/13.png)
Answer:
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 ggl_rates
GO
5
TRUNCATE TABLE ggl_rates
GO
SELECT COUNT(*) FROM ggl_rates
GO
0
* 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 ggl_rates
GO
5
TRUNCATE TABLE ggl_rates
GO
SELECT COUNT(*) FROM ggl_rates
GO
0
Download MS SQL Server Interview Questions And Answers
PDF
Previous Question | Next Question |
How To Delete Multiple Rows with One DELETE Statement in MS SQL Server? | How To Join Two Tables in a Single Query in MS SQL Server? |