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

What is a natural primary key?

952

What is the log shipping?

952

What is the main purpose of having conversation group?

848

What is advantage data architect?

869

What is difference between joins and subqueries?

1053

what is a sub-report?

132

What is the distinction amongst delete and truncate?

1003

Define full outer join?

894

What is a result set object returned by mssql_query()?

1078

Create and insert into temp table in sql server?

978

What is a select query statement in ms sql server?

1009

What new changes are being made in SQL Server?

1100

What are the types of normalization?

972

What are the Advantages of using CTE in sql server?

1043

List the ways in which dynamic sql can be executed?

972