Home All Groups Group Topic Archive Search About

what is the difference between truncate and delete

Author
11 Aug 2006 7:03 AM
SQLken@gmail.com
Hi,
i've been using both delete and truncate a table, but don't know
exactly the differences between them.
Thanks

Ken

Author
11 Aug 2006 7:19 AM
Jens
Hi,

without having to quote the whole BOL, you can find the bullet points
of differences listed here with explanations:

http://msdn2.microsoft.com/de-de/library/ms177570.aspx

HTH, jens Suessmeyer.

---
http://www.sqlserver2005.de
---
Author
11 Aug 2006 7:39 AM
ML
How did you guess SQLken speaks German? :)


ML

---
http://milambda.blogspot.com/
Author
11 Aug 2006 8:00 AM
Jens
Seems, that the redirector put me to the german site of MSDN :-)

-jens.
Author
11 Aug 2006 8:10 AM
ML
They know EVERYTHING. :)


ML

---
http://milambda.blogspot.com/

AddThis Social Bookmark Button