hi
What is the difference Truncate and Drop command in SQL Server?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Satyapriya NayakPosted Dec 9, 2011, 6:47 AM
Drop means removing the existing object from the database (Both data and structure of the table gets removed).
Truncate will delete only the data while Keeping the structure of the table as it is.
Thanks
VulpesPosted Dec 9, 2011, 6:41 AM
http://www.c-sharpcorner.com/Forums/Thread/134569/what-is-the-difference-between-drop-delete-and-truncate.aspx