Is truncating a table faster than dropping and re-creating it in SQL? Thanks Azbilegt Chuluunbat

[Azbilegt Chuluunbat]

I am interested in to see if truncating the table is actually faster than dropping and recreating it? Does one of the write to the log?

[Lost User]

There is a simple way to find the answer.

[Dave Kreskowiak]

What did you find out when you tried both methods?

Asking questions is a skill CodeProject Forum Guidelines Google: C# How to debug code Seriously, go read these articles.
Dave Kreskowiak

[BabyYoda]

It may depend on things but generally speaking DROP will be faster than TRUNCATE. And TRUNCATE is faster than DELETE.

[Lost User]

I would think that truncating means less "file allocation" processing (just changing a pointer?) Dropping and recreating is essentially creating a new file / entry.

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it. ― Confucian Analects: Rules of Confucius about his food