How can truncate data from table in sql server 2008 ?


truncate table TESTTABLE
tablename >> TESTTABLE
Remove all row from table .
TRUNCATE TABLE removes the data by deallocating the data pages used to store the table s data.

Share on facebook Google Twitter

Web Engineers here !

Grideb is the group of engineers who provide excellent solution for domain scenario with experienced, talented and high skilled engineers. We work hard to reduce complication of user interface and improve better quality of service.

-- Chief Executive Officer, GRIDEB SERVICES

Contact Us

Office-1,FF ,One Square Office Mall
Uttar Pradesh 201004 (INDIA)
P: +91 (120) 260-6044
M: +91 90-1300-3421
Email ID

Grideb Services 2013-2014