the delete command log all the stmts in the transaction log and the trunc

What is the difference between DELETE and TRUNCATE?

Question Posted / althaf

Answer Posted / althaf

the delete command log all the stmts in the transaction log
and the truncate command dont log the stmts.

Is This Answer Correct ?

8 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is mutating error?

966

What is the maximum number of columns in sql table?

1172

What is a file delimiter?

1094

what is 'mysqladmin' in mysql? : Sql dba

1025

How can you select unique records from a table?

1077

what is a stored procedure? : Sql dba

1132

How to use boolean type in select statement?

1074

What is fmtonly in sql?

1085

Does group by remove duplicates?

1042

How much does sqlite cost?

1038

When do we use triggers?

1079

What is percent sign in sql?

1283

How do you create a unique index?

1047

What is sql and db2?

1004

Why is stored procedure faster than query?

960