How to use truncate in SQL Server?

Question

I want to see a few examples about the use of truncate in SQL Server. Please guide me.

Govinda Rajulu Yemineni · Answer

Hi http://www.tutorialspoint.com/sql/sql-truncate-table.htm https://technet.microsoft.com/en-us/library/aa260621(v=sql.80).aspx https://msdn.microsoft.com/en-in/library/ms177570.aspx

Jignesh Trivedi · Answer

It removes all the row from the table or specified partition of the table. truncate table is same as Delete table with out where condition and truncate table is faster than delete table Please refer below link https://msdn.microsoft.com/en-in/library/ms177570.aspx

Vignesh Mani · Answer

Hi please below link http://www.techonthenet.com/sql_server/truncate.php

Vignesh Mani · Answer

TRUNCATE TABLE table_name