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