TRUNCATE TABLE Statement in SQL Server database

Live video:

TRUNCATE TABLE Statement

TRUNCATE statement in SQL like delete statement but that use for delete all records from table.The main difference between the delete and truncate is that you can roll back the DELETE statement if you choose, but you can't roll back the TRUNCATE TABLE statement.

Syntax:

TRUNCATE TABLE [Table_Name]

Note: Replace [Table_Name] with actual table name e.g table name "Customers"