What is Truncate Command in SQL SERVER?
TRUNCATE Commands deletes all data from a table. The TRUNCATE command is similar to the DELETE command but it is like dropping a table and recreating it again.
After using the TRUNCATE command all auto-increment values are reset and will begin from the beginning.
Using Truncate Command in SQL SERVER
TRUNCATE table WareHouse
The above command deletes all data from the table WareHouse.
Drop Table in SQL SERVER
DROP table WareHouse
The Command deletes the table schema as well as data. If you needed that table you need to re-create that table.
Support us by sharing this post