Truncate statement

Question

0.00/5 (No votes)

See more:

Hi,

I am a beginner in sql and I have some confusiom abou truncate. My question is how the truncate command is different from delete? Which one is best for query? Please help me or give me any link where I can learn about it.

Thanks in advance.

Posted 19-Dec-10 23:14pm

MDNadeemAkhter

Updated 19-Dec-10 23:15pm

JF2015

v2

Add a Solution

Comments

JF2015 20-Dec-10 5:15am

Edited for spelling and grammar.

2 solutions

Solution 1

Try this,
http://www.technoreader.com/Difference-between-Truncate-and-Delete-in-SQL.aspx[^]

http://www.dotnetspider.com/resources/4408-Difference-between-delete-truncate-command.aspx[^]

Posted 19-Dec-10 23:17pm

Toniyo Jackson

Comments

Dalek Dave 20-Dec-10 5:51am

Good Links.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RaviRanjanKr · Accepted Answer · 2010-12-19T23:19:00

The actual difference between Delete and Truncate Table command for delete table is that
a) A Truncate table statement is executed much faster than delete table.
b) Truncate table does not support the where clause.
c) Truncate Table Statement does not fire a trigger. When truncate is used, the deleted rows are not entered in the transaction log.
d) You can also not use Truncate Table statement for delete table which is referenced by Foreign key constraint.

and it depends upon query which is better between Delete and Truncate Table Command. if you want to delete all table means not want to use selected value from table then in that case Truncate Tablewill be the best

For more details navigate the given link
difference between DELETE and TRUNCATE[^]

Hope it will works for you.