What is the difference between DELETE and TRUNCATE?
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 |
Post New Answer View All Answers
What is mutating error?
What is the maximum number of columns in sql table?
What is a file delimiter?
what is 'mysqladmin' in mysql? : Sql dba
How can you select unique records from a table?
what is a stored procedure? : Sql dba
How to use boolean type in select statement?
What is fmtonly in sql?
Does group by remove duplicates?
How much does sqlite cost?
When do we use triggers?
What is percent sign in sql?
How do you create a unique index?
What is sql and db2?
Why is stored procedure faster than query?