Truncate Table in SQL Server

In SQL Server by Baqir AliLeave a Comment

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

About the Author

Baqir Ali

Facebook Twitter

Hi, I am Baqir Ali ---- Blogger, Programmer, and a Teacher. I am currently working as a Programmer for Softnat Technologies. I have tons of ideas and data to share with you all via blogging.

Leave a Comment