Truncate deletes all rows from table. But Delete deletes row/rows by cond

What is the difference between truncate and delete statement?

Question Posted / rajiv singh

Answer Posted / rajiv singh

Truncate deletes all rows from table. But Delete deletes
row/rows by condition.

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Does the unique constraint create an index?

1054

Explain can SSRS reports Cache results?

158

What is nolock?

974

What extended events?

1001

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1923

What are the transaction properties?

1009

What are temporal tables in sql server 2016?

881

How to enter date and time literals in ms sql server?

1012

Can coalesce return null?

1005

Explain how to use linked server?

988

Tell me what is difference between clustered and non clustered index?

942

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

121

What do you mean by an execution plan? Why is it used?

1021

Do you know how to implement service broker?

928

What is the syntax to execute the sys.dm_db_missing_index_details?

1021