In this article i will explain what is Truncate Command and how to use Truncate Command in SQL Server.
In previous articles i explained How to create a table in SQL Server, How to alter table column in SQL Server, How to add a column to table and How to delete a column from table in SQL Server, How to rename a column and How to rename a table in SQL Server, Update Command, and Delete Command. Now i will explain what is Truncate Command and how to use Truncate Command in SQL Server.
Here i'm using Employee table.
By Truncate command all the records will be deleted at a time and we can't get data, by using Delete command we can restore the data because the description of each record is maintained in the log file.
Truncate table <table-name>
Truncate table Employee
Execute the above statement. All records will be deleted at a time.
Note: If there is any identity column then Identity Seed will be reset to start value.