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

How to update multiple rows with one update statement in ms sql server?

1259

Do you know what is xpath?

1152

Suggest a method of joining two tables.

1228

What Are the Main Features of SQL Azure?

121

Which tools are available to manage SQL Azure databases and servers?

115

What are the restrictions that views have to follow? : SQL Server Architecture

1058

Explain about unique identifier data type in sql server?

974

What is use of @@ spid in sql server?

1267

What are SSL and TSL protocols?

1030

Who is the owner of a schema in ms sql server?

1116

How can you list all the columns in a database?

970

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

952

What is the difference between ‘having’ clause and a ‘where’ clause?

1083

What are pages and extents? : SQL Server Architecture

1068

What is simple indexing method?

1083